Temporary Table Options

The Options clauses of CREATE Temporary TABLE let you specify storage locations, locking modes, and user-defined access methods. You cannot specify the size of the initial or next extents for a temporary table. Extents for a temporary table always have a size of eight pages.

Options:
 
|--+--------------------+--------------------------------------->
   |  (1)               |
   '--------WITH CRCOLS-'
 
>--+---------------------------------+-------------------------->
   |  (2)                       (3)  |
   '--------| Storage Options |------'
 
>--+----------------------------+------------------------------->
   |                       (4)  |
   '-| LOCK MODE Options |------'
 
>--+-------------------------------------+----------------------|
   |                                (5)  |
   '-| USING Access-Method Clause |------'
 

1. Dynamic Server only
2. Informix extension
3. See page Storage Options
4. See page LOCK MODE Options
5. See page USING Access-Method Clause (IDS)

This is a subset of the syntax of Options Clauses that the CREATE TABLE statement supports.