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