Additional Statement

Description

SET AUTOCOMMIT on/off;     (default=OFF)

Commit/do not automatically commit transactions.

SET CATALOG catalog;

Set (change) the catalog to catalog.

SET HEADER on/off;              (default=OFF)

Display/suppress column header if there are no matching rows.

SET HEXDUMP on/off;           (default=OFF)

Display data in HEXADECIMAL and CHARACTER format.

SET LENGTH/COLSIZE nnn;  (default=128)

Set the maximum display length of nnn characters for columns.

SET LINE/PAGESIZE nnn;

Displays report in segments of nnn lines. To continue, the user must press <Enter>.

SET MARK on/off;                 (default=OFF)

Displays a NULL value with/without an exclamation mark (!).

SET SCHEMA schema;

Set (change) the schema to schema.

SET TERMINATE on/off;        (default=OFF)

Terminate/Continue processing on SQL error.

SET WIDTH/ROWSIZE nnn;

Displays a  report with a width of nnn characters.

SHOW TABLE table;      

Displays the column definitions of the specified table.

The table is a concatenation of catalog, schema, and table name delimited by "...".

Catalog and schema are optional.

Valid combinations are :

    catalog.schema.table

    catalog..table

    schema.table

    table