we read data from an Oracle database. The desired order is created by an 'order by' in the sql statement. The individual elements of the result set are converted into objects and inserted into a parent object using 'insert' on a property, which implements a one-to-many relationship with the result objects. Later, we iterate over the objects in a for loop and process the contents. At this point the order is apparently no longer identical to the order in which the elements were inserted.
There is an undocumented command, $preprocess, that can be called as below. In this case it takes the class name and converts its code into a text array. That includes comments as well. Two questions about it if you know:
I have a REST client that calls a REST service and as a response gets a stream containing a JSON structure. The service is placing some weird non-printable characters into some places in the JSON document that is throwing off parsing of a down-stream XML document.
What I would like to do is just remove the non-printable characters from the response stream that comes back from my call to the REST service.
Does anyone have a handy utility or method for removing all non-printable characters from a character stream?
A month ago, we purchased the cache license for a 10user limitation. We are a 6developers and using 3different development (internal)servers for this same license. All Developers aren't login at the same time. We have a limitation for login 2developers at a time in a server. But sometimes, we are facing a <LICENSE LIMIT EXCEEDED> issue. We don't know why we are facing this one. So anyone please guide me, why we are getting this type of issue. I have attached the errored screenshot.
I need to show the absence of data, so I have to join the list of predefined values with a result of a select statement. However, it seems like Table Value Constructors in JOIN are either not supported, or I do not understand the syntax. Basically, I am going for something like this:
Select v.valueId, m.name
From (values (1), (2), (3), (4), (5)) v(valueId)
left Join otherTable m
on m.id = v.valueId
I want to create a Sample Database for Cache InterSystems and want to access it via Cache Entity Framework Provider. But, I cannot find a particular engine of Management Portal to create a database.
Can you guide how to install Management Portal in Windows?
Let's say I have a persistent class Sales. I need to create a report that shows the amount of sales for each branch. By simply using the class Sales for the source of the cube, I can show what I want with one little exception - the branches that did not have any sales are not shown. Is there a way around that that does not involve creating a whole new table just for this cube or using a Data connector (they have horrible documentation and I am unable to figure out how to use them properly)?
The boss (reasonable intelligent ;-) wants to connect to the cache database through Excel, but unless I explain what he's looking for (field names DB names etc) then I can see him continually coming back for "what's the link here and how do I get the delivery company name etc etc"
is there a SAFE way I can give him access to our database using an intelligent visual user interface.
I had thought about the SQL Query Builder within the management portal, but the thought of giving him access to all of the other functionality of the management portal.
I want to consume external websocket api, URL looks like this:
wss://site.com/ws/v2/?&token=<token>
Checked with external tool (Simple WebSocket Client) that websocket works and I can consume the data.
In Cache the relevant functionality is offered by %IO.Socket class.
set sock = ##class(%IO.Socket).%New()
set sock.SSLConfig = "MyEmptySSLConfig"
set sock.TranslationTable="UTF8"
do sock.Open("site.com/ws/v2/?&token=<token>","443", 10,.sc)
By update
.png)