Local Temporary Tables (Magic xpa 4.x)
A local temporary table is visible only in the current session and is dropped automatically at the end of the current session. Its name is prefixed with a single number sign (#table_name).
![](/PublicKnowledge/servlet/rtaImage?eid=ka23z0000004PUX&feoid=00ND0000005rAjf&refid=0EM3z000001reAd)
|
-
Local temporary tables cannot be created in a subtask. To create a local temporary table on the fly, you must define it in the DB table of the parent task. Another option is to work with global temporary tables.
-
Local temporary tables cannot be viewed using Direct SQL. Use global temporary tables instead.
|