Names the temporary table. The qualifier,
if specified explicitly, must be SESSION, otherwise an error is returned.
If the qualifier is not specified, it is implicitly defined to be SESSION.
If a declared temporary table, or an index or view that is dependent on a
declared temporary table already exists with the same name, an error is returned.
If a persistent table, view, index, or alias already exists with the same
name and the schema name SESSION:
- The declared temporary table is still defined with SESSION.table-name. An error is not issued because the resolution of a declared temporary
table name does not include a permanent library.
- Any references to SESSION.table-name will resolve to the declared
temporary table rather than to a permanent table, view, index, or alias with
a name of SESSION.table-name.
The table will be created in library QTEMP.