create index UIX on MyTable (Column1) where Column1 is not null
2. What happens if we add an index on a property that is NOT required, meanning that not all records will be indexed because we do not allow null subscripts ?
I have a list of %Library.ArrayOfObjects . Each of list elements has some properties. I have to sort list by one of its objects properties. Is there a predefined method to doing that? (quicksort maybe?)
I need to find out if it is possible somehow to receive actual linux TIMESTAMP for example with $NOW() or other functions. I was trying to recalculate it with $NOW() function, but without success. I would like to simulate Redis TIME command in COS.
My tryings:
USER > set time = $NOW()
USER > w (($PIECE(time,",",1)*86399) + $PIECE(time,",",2))
5573319043.403186
I'm using device redirection to intercept incoming writes and need to figure a smart way to detect when to CLRF in order to prevent misleading outputs.
So basically, if the intercepted write ends with !, I need to know that and prevent my routine from writing ! as well.
Okay, so I ran into a rather odd bug. I have a remote test machine (tst-intersystems) running for which I accidently opened a lot of windows in my Studio (i.e. 500+). The result is that the studio runs out of memory and crashes. Now, every time I try to connect to this remote machine studio immediately attempts to open all windows effectively not allowing me to start studio anymore.
In a previous exercise, I was able to show the power of Caché. A medium-designed set of interdependent tables with some GB of data. URLs cross reference over some million pages resulting in ~3 billion records
Competition was between
Caché
PostgreSQL
MySQL
Criteria were Speed + Storage consumption I composed a customized loader fed over a "raw" TCP connection Mapping the "objects" into the final table by directly writing to Global Storage.,
There is an interesting discussion in the neighboring topic which raises a question for me: is there any reason to have %Status as a return value for COS method?
In reviewing the documentation found here, it states that there is an Attributes property. Since this is an array, I was wondering how I would go about traversing through the array to review what attributes are available on the file.
I am running a ZBREAK trace on a legacy FDBMS application that uses arrays but rather than displaying the array value contents, I am seeing logs similar to the following.
Trace: ZBREAK SET LINE=Array Val at BIOPWR+6^BIOPWR
I have some constants hardcoded in my class as parameter values, and those constants are referenced in many places in my module. Now the need has arisen to provide different value for those parameters depending on some context. Is it possible to create some sort of accessor method for the parameter (like it is possible for properties), or do I need to perform a thorough refactoring?
Have very little XML experience and have been able to manually create output. Have a need to take data that I store in a M global (example: ^TML("HDATA", ) and out put it in CCDA XML format.
Are there any examples of M code using the XMLWriter to accomplish this?
I'm trying to use WebSocket for my application. I am trying to get the example in this link (http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...) to work. However, I keep getting the error "CSP application closed the connection before sending a complete response". Does anyone know why?
I would like to know how to detect in Caché ObjectScript if data saved in string is number and furthermore, if it's type is integer.
I maybe found a solution:
set value = "44.2d3"
try{ set status = $INUMBER(value,"") if ('$FIND(+value,".")){ w "your variable: '"_value_"' is number and integer" }else{ w "variable is number but no integer" } }catch(e){ w "variable is not number" }
Hi, I would like to read a row out of an external SQL table and reference the returned results directly from my cache class. I've set up a link table and a SQL gateway connection. but I'm not real sure how to use them in COS. Anyone have examples out there, or some assistance? Thank you.
I am currently in need of a way to serve files dynamically (sending specific replacements for when the requested file doesn't exist, possibly depending on other conditions such as passed parameters).