Local Temporary Tables (Magic xpa 3.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).
Note:
|
-
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.
|