The user can specify whether to use a temporary table within a session of the application program or within a
transaction. Stored data is erased after the session or transaction terminates.
The storage structure of a temporary table is SEQUENTIAL. The storage structure of the index of a temporary table is
BTREE. The storage structures are automatically defined.
Defining a temporary table
Use the CREATE TABLE statement to define a temporary table.
A sample temporary table definition follows.
This sample definition defines the STOCK_TEMPORARY table for database spaces DBSP_1 and DBSP_2.
Example:
CREATE TABLE statement for defining the STOCK_TEMPORARY table
Table name
Specify a name to be assigned to a temporary table. Specify up to 36 alphanumeric characters for a table name,
whose first character must be an alphabetic character. The table name must be qualified by a schema name.
Table elements
Specify the name, data type, default value, and constraint of each column in a temporary table. Specify up to 36
75
