Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Temporary Tables in InterSystems IRIS

Discussion
Eduard Lebedyuk · Mar 6, 2020

Temporary Tables in InterSystems IRIS

Temporary tables are tables available for a current process only (and destroyed when process ends).

What are you approaches to creating temporary tables?

Here's the two I know:
  1. Process-private Globals storage can be used as a data global in storage definition. That way, each process can have its own objects for the class with ppg storage.  Here's how. Here's how 2.
  2. InterSystems TSQL supports #tablename temporary tables. A #tablename temporary table is visible to the current procedure of the current process. It is also visible to any procedure called from the current procedure. #tablename syntax is only supported in TSQL procedures (class methods projected as procedures with language tsql).

Any other ways to achieve similar functionality? 

#SQL #InterSystems IRIS

Source URL:https://community.intersystems.com/post/temporary-tables-intersystems-iris