1  –  dec-local-col-definition

    The definition for a column in the table. SQL gives you two ways
    to specify column definitions:

    o  By directly specifying a data type to associate with a column
       name

    o  By naming a domain that indirectly specifies a data type to
       associate with a column name

    See the CREATE TABLE for more information about column
    definitions. See the Data_Types HELP topic for more information
    about data types.

2  –  COMPRESSION_IS

    Syntax options:

    COMPRESSION IS ENABLED | COMPRESSION IS DISABLED

    Specifies whether run-length compression is enabled or disabled
    for rows inserted into the declared local temporary table.

    In some cases, the data inserted into a local temporary table may
    not compress and so incur only overhead in the row. This overhead
    is used by Rdb to describe the sequence of uncompressible data.
    Use COMPRESSION IS DISABLED to prevent Rdb from attempting the
    compression of such data.

    The default is COMPRESSION IS ENABLED.

3  –  ON_COMMIT

    Syntax options:

    ON COMMIT PRESERVE ROWS | ON COMMIT DELETE ROWS

    Specifies whether data is preserved or deleted after a COMMIT
    statement for declared local temporary tables.

    The default, if not specified, is ON COMMIT DELETE ROWS.

4  –  table-name

    The name of the table you want to declare. You can optionally
    precede the table-name with an alias-name and a period (.).  You
    must, however, precede the table-name with the keyword MODULE and
    a period (.),  for example, MODULE.EMPL_PAYROLL.