go to post Eduard Lebedyuk · Jul 8, 2018 SELECT $TRANSLATE(CallbackComment ,'''','?') FROM SQ.CBPhoneResult_View WHERE PhoneDateODBC = '2018-04-09' Also try %EXTERNAL(CallbackComment)%INTERNAL(CallbackComment)%ODBCOUT(CallbackComment)
go to post Eduard Lebedyuk · Jul 7, 2018 As i have mentioned that i am using the Intersystem ODBCWhere? I thought you were using SMP.Try to change SELECT field CallbackComment to one of:%EXTERNAL(CallbackComment)%INTERNAL(CallbackComment)%ODBCOUT(CallbackComment)
go to post Eduard Lebedyuk · Jul 7, 2018 Looks like Timeout issue.1. Do you have index on PhoneDateODBC?2. Can you execute the same query using some JDBC tool?
go to post Eduard Lebedyuk · Jul 6, 2018 You can receive all filter values for cube if you pass its name as a datasource: /Info/FilterMembers/YourCubeName
go to post Eduard Lebedyuk · Jul 6, 2018 Here's an output I get: USER> USER> USER> This is written by INT routine USER> which is created from a script injected to csession. USER> USER> D ^MyBootRoutine ^ <NOROUTINE> *MyBootRoutine USER> USER> USER> Looks like it's still line-by-line execution.
go to post Eduard Lebedyuk · Jul 6, 2018 It's executed during container build, so to load something I need a script.
go to post Eduard Lebedyuk · Jul 6, 2018 This answer by @Timothy Leavitt explains how to get CLS line from INT line.Maybe we can add that functionality to Atelier?
go to post Eduard Lebedyuk · Jul 5, 2018 First you need to load CSV into class.After that you can convert objects of your new class into json using SQL JSON_OBJECT function or %ZEN.Auxiliary.altJSONProvider.
go to post Eduard Lebedyuk · Jul 5, 2018 You can determine, where does the message comes from by inspecting it's header, get header Id from: $$$JobCurrentHeaderId and query Ens.MessageHeader class. Alternatively, check "process" variable in BPL or current context in ObjectScript processes. Maybe the whole object would be available somewhere.
go to post Eduard Lebedyuk · Jul 4, 2018 Check out this list of tools for C#/InterSystems interoperability.I think you need Caché Managed Provider for .NET.In <installdir>\dev\dotnet there are several examples available.
go to post Eduard Lebedyuk · Jul 3, 2018 Here's an example of accessing properties and array elements: set jsonObj = [].%FromJSON(filename) set i = jsonObj.resultSets.%GetIterator() while i.%GetNext(.key , .resultSet ) { set i2 = resultSet.rowSet.%GetIterator() write resultSet.name,! while i2.%GetNext(.key , .rowSet ) { write rowSet.%Get(0),! } }
go to post Eduard Lebedyuk · Jul 3, 2018 $zu(68,40,switch) can be replaced with: set old=$system.Process.SetZEOF(switch) Also, what does this command do? kill ^TMP($zn,$j)
go to post Eduard Lebedyuk · Jul 3, 2018 This error indicates that either login and password are incorrect or that user has insufficient permissions to access management portal.
go to post Eduard Lebedyuk · Jul 2, 2018 Generally you'll need to check the service and adapter method lists. Callbachs are often called "On*".Similar discussion for SQL adapter.
go to post Eduard Lebedyuk · Jul 2, 2018 1. Connect to other system via xDBC2. Query %Dictionary package on a local and remote system and compare results.
go to post Eduard Lebedyuk · Jun 29, 2018 But prior to 2010.1 we didn't have $NAMESPACEAs @Lucas.Fernandes uses $namespace in his solution: #dim currentNamespace As %String = $namespace that is not a concern in this particular case.
go to post Eduard Lebedyuk · Jun 28, 2018 Here's my URL template jdbc:Cache://{host}[:{port}]/{database} If you connect but get Access Denied, try user with %ALL permissions to remove doubts about insufficient privileges.
