Use the CREATE SCRATCH TABLE statement to create a non-logging temporary
table in the current database. Only Extended Parallel Server supports this statement, which
is an extension to the ANSI/ISO standard for SQL.
>>-CREATE--SCRATCH--TABLE--table-------------------------------->
>--| Scratch Table Definition |--------------------------------><
Scratch Table Definition:
.-,--------------------------.
V (1) |
|--(----| Column Definition |------+--+-------------------------------------------------------+--)-->
| .-,----------------------------------------------. |
| V (2) | |
'-,----+-| Multiple-Column Constraint Format |------+-+-'
| (1) |
'-| Column Definition |----------------------'
>--+---------------------------+--------------------------------|
'-| Scratch Table Options |-'
Scratch Table Options:
|--+-------------------------------------+---------------------->
'-IN--+-dbslice---------------------+-'
+-dbspace---------------------+
| (3) |
'-| FRAGMENT BY Clause |------'
>--+----------------------+-------------------------------------|
| .-PAGE--. |
'-LOCK MODE--+-ROW---+-'
'-TABLE-'
Notes:
- See Column Definition
- See Multiple-Column Constraint Format
- See FRAGMENT BY Clause
| Element |
Description |
Restrictions |
Syntax |
| dbslice |
Name of dbslice to store table |
Must already exist |
Identifier |
| dbspace |
Name of dbspace to store table.
Default is the dbspace that stores the current database. |
Must already exist |
Identifier |
| table |
Name that you declare here for a nonlogging temporary table |
Must be unique in the current session |
Database Object Name |