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:
- 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.
- 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?