Filter
Top Products
alphanumeric characters for a column name, whose first character must be an alphabetic character. Each column
name within the table must be unique.
Row deletion specification
Specify when to delete a row in a temporary table. If this argument is omitted, the temporary table is assumed to be
used within a transaction, and data stored in the temporary table is deleted when the transaction terminates.
DELETE ROWS:
The temporary table is assumed to be used within a transaction, and data stored in the temporary table is
deleted when the transaction terminates.
PRESERVE ROWS:
The temporary table is assumed to be used in a session, and data stored in the temporary table is deleted
when the session terminates.
Comment definition
For a temporary table, a comment can be specified with a character string or national character string. A character
string of up to 256 bytes can be specified. Both a character string and national character string can be specified as a
comment. If no comment is necessary, omit the specification.
Database space name
Specify the name of a physical database space in which to store data.
Number of users
Specify the number of temporary tables to create in a database space. Specify the number of users so that the total
number of database space users indicates the multiplicity of the application program that uses the temporary tables.
DSO name and DSI name of temporary table
The DSO name and DSI name of a temporary table begin with _TEMP.
Defining an index
Use the CREATE INDEX statement to define an index. In the index definition, specify the columns that form the index
key.
A sample index definition for a temporary table follows.
This sample definition defines an index for the STOCK_TEMPORARY table.
Example:
CREATE INDEX statement for defining an index
Remarks: KEY (ITMNO, STOCKQTY) is a key specification.
Index name
Define a name (index name) to be assigned to an index. Specify up to 36 alphanumeric characters for the index name,
whose first character must be an alphabetic character.
Key specification
Specify the name of a column to be used as the index key. Multiple columns can be combined to form a single index.
76