InterSystems ObjectScript is a scripting language to operate with data using any data model of InterSystems Data Platform (Objects, Relational, Key-Value, Document, Globals) and to develop business logic for serverside applications on InterSystems Data Platform.
I am currently working on a issue with WRC on one of my Inbound SQL Adapters not returning all the records it should be. If I looked at the count of the records in Ensemble and compare it to that of a Microsoft SQL View, Ensemble seems to be off by a few records here and there. I am using a full dynamic select statement in my settings of the adapter.
While i am trying to write a data i am getting a error as "<PROPERTY DOES NOT EXIST>zFile+15^User.zKQRest.1 *value,%Collection.ListOfObj" but there are values stored in it. How can i break it write it separately.
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
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?
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" }
In this article I would like to tell you about macros in InterSystems Caché. A macro is a symbolic name that is replaced with a set of instructions during compilation. A macro can “unfold” in various instruction sets each time it is called, depending on the parameters passed to it and activated scenarios. This can be both static code and the result of ObjectScript execution. Let's take a look at how you can use them in your application.
I have a situation where I write a character stream to a file. The file content gets signed and the signature is sent to a service provider together with the file content.
The signing is done using openssl.
This works perfectly on a dev PC, which is runnning Windows and has a little-endian architecture.
The problem is as soon as I do this on the server, which has a big-endian architecture, the signed value is incorrect according to the service provider.
The content is signed using RSA SHA256 with PSS padding.
It is my understanding that when a routine accesses a global it is temporarily stored in global memory. While the global is within global memory, any other routine would be able to readily access the global from memory and not from disk so long as the same node is being utilized.
Is there any way to change a class definition (especifically a query definition during the compilation time)? The idea is: I have an abstract class with a parameter where I will define the ROWSPEC of a query and some methods to populate e temporary table The implementation class will override the parameter, specifying the ROWSPEC of this implementation, and the methods will populate the rows in the same format as the ROWSPEC.
I know how to iterate through the One side of the relationship and for each One iterate through all the various Manys.
What I have been trying to figure out, is the code (I can put into a Class) that will start at the top of the Manys, iterate down and for each of the Manys, pull the associated One.
I can do this with SQL or Globals, but I want to use only Class type code.
Every row-and-column intersection contains exactly one value from the applicable domain (and nothing else).
The same value can be atomic or non-atomic depending on the purpose of this value. For example, “4286” can be
atomic, if its denotes “a credit card’s PIN code” (if it’s broken down or reshuffled, it is of no use any longer)
non-atomic, if it’s just a “sequence of numbers” (the value still makes sense if broken down into several parts or reshuffled)
This article explores the standard methods of increasing the performance of SQL queries involving the following types of fields: string, date, simple list (in the $LB format), "list of <...>" and "array of <...>".
I needed to pass through a file with Ensemble but the operation wasn't writing some filenames as given because the EnsLib.File.PassthroughOperation 'sanitizes' filenames removing characters that are not valid on some operating systems; 09000655_AEDC_C3344059_A/E_Martin Browne_09000655_201706221018.pdf 09000655_AEDC_C3344059_A#47E_Martin_Browne_09000655_201706221018.pdf
Caché offers a number of methods for going through a collection and doing something with its elements. The easiest method uses a while-loop and lets you fulfill the task in an imperative manner. The developer needs to take care of the iterator, jumping to the next element and checking if the loop is within the collection.
Good day, I have this issue. I have global like: ^myglobal(varX) = $LB(var1,var2). I need to delete all globals that have variable var1 in that list same without a need to iterate through all globals and checking their value.
Good day, I would like to find out the size of Caché ObjectScript variable in order to guarantee that my program will not leak, equally in terminal and Caché globals. For example how huge number I can store in that variable ? And what happen in Caché when variable will leak ? How is this behavior treated? (how much memory is reserved for common variable?)
Sometimes, it comes in very handy (especially for the EAV model) to use array properties in a class and be able to qickly search by their elements: both the key and the value.
Note: Please note that the exact functional equivalent of Python slices has never been implemented in Caché, since this functionality has never been required.
This discussion is open to anyone who use or know about WebTerminal project. It is a result of a long story of the project development, testing and maintaining.
Here's my issue. I've been using Sample.* globals and packages mapped to another development namespace to realize unit tests. So when I ran it, I notice that I forgot to start a transaction in order to be able rollback it to it's original data.
I assumed that I should use transactions since I was manipulating it's data but I didn't want it to be persisted.
By update