Additional Statements
In addition to the standard SQL statements, the following statements can be used:

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