#Video

Post a job Follow
0 Followers · 866 Posts

Here you can find announcements on videos related to InterSystems Data Platform.

Post a job Follow
Article Robert Cemper · Jan 23, 2023 2m read

Global-Streams-to-SQL

In general Global Streams are data objects embedded in Classes / Tables.
Using and viewing them with SQL is normally a part of the access to the containing tables.

SO WHAT?

During debugging or searching for strange or unexpected behavior there could be the need to 
get closer to the stored stream. No big problem with direct access to Globals with SMP or Terminal.
But with SQL you are lost.
So my tool provides dynamic access to Global Streams wherever you may need this
Special thanks to  @Oliver Wilms  for the inspiration for this tool.    

#Caché #InterSystems IRIS #Video
Open Exchange
1
1 568
Article Robert Cemper · Jan 30, 2023 2m read

JSONfile-to-Global #1

The similarity between JSON objects + arrays and Globals in IRIS or Caché is evident.
With small and medium size JSON objects navigation across %Dynamic Objects is comfortable.
But with large and/or deep cascaded objects it becomes a challenge.

The presented tool offers 3 variants

  • loading an already existing %Dyamic object or Array into a global of your choice
  • loading a %Stream containing a JSON object into a global of your choice
  • loading an external File containing a JSON object into a global of your choice
#InterSystems IRIS #Open Exchange #Globals #JSON #Tips & Tricks #Tools #Video
Open Exchange
1
2 323
Article Robert Cemper · Jan 23, 2023 2m read

Global-Streams-to-SQL #2

Some technical background information

There is not just one class in this package:  rcc.gstream.cls but also rcc.gstreamT.cls

While rcc.gstream works with direct access to the stream globals, the *T version uses
a Process Private Global (PPG) as Temporary storage.
using  SELECT * FROM RCC.gstreamT WHERE RCC.useT('^jpgS')=1 and similar.

#InterSystems IRIS #Other #Video
0
0 313