- Log in to post comments
User bio
my video https://youtu.be/zx6WoApljBI
my business story https://community.intersystems.com/post/45-years-intersystems-1978-2023
- main languages: German, English, Italian, French, Spanish, Latin, ..
- private: married since 1969, 3 successful children
Member since Jul 21, 2017
Posts:
Replies:
A very dirty hack: possible not really a recommendation
IF Source table is not mapped to ONS
- copy class definition including <Storage> from ENS to ONS
- in <STORAGE> you see
-
<DataLocation>^Sample.EmployeeD</DataLocation> <IdLocation>^Sample.EmployeeD</IdLocation> <IndexLocation>^Sample.EmployeeI</IndexLocation> <StreamLocation>^Sample.EmployeeS</StreamLocation> - Now replace all ^ by ^|"ENS"| looks similar
For my example, it's ^|"SAMPLES"| -
<DataLocation>^|"SAMPLES"|Sample.EmployeeD</DataLocation> <IdLocation>^"|SAMPLES"|Sample.EmployeeD</IdLocation> <IndexLocation>^|"SAMPLES"|Sample.EmployeeI</IndexLocation> <StreamLocation>^|"SAMPLES"|Sample.EmployeeS</StreamLocation> - Extended Global references allow access to the other namespace. Nothing new, but risky
- Log in to post comments
YES Sir!
- Process private globals live in IRISTEMP and are strictly bound to the process and its lifetime.
- The package with %ZZ.* makes sure it is visible from ALL namespaces
- At process start it is always empty
- you fill it implicitely by CREATE at definiftion time
- or if reused by
INSERT INTO %ZZ.resultset SELECT ....... - this SELECT must be the same as in CREATE ...
to fit column names
- Either CREATE once + INSERT later works
- Or DROP TABLE %ZZ..... and fresh CREATE ...
- It's a matter of taste, I tried both
Warning:
Test from MGMT Portal (SQL) doesn't work as the process
(and its ID) in background changes. The process stops and the content is gone.
IF your table must survive several processes, you need some
other tricky solution based on the same basic idea of %ZZ*
combined with a manually tuned Class definition.
- Log in to post comments
Open Exchange applications:
Certifications & Credly badges:
Robert has no Certifications & Credly badges yet.
Followers:
Following:
assuming Document.StreamGC is of type %Stream.Object you may
use method FindAt which combines Read() and Contains()
see: method FindAt()