OS/390 DB2 Table Describe Utility

describe is a DB2 utility which runs on OpenEdition.  It connects to an
MVS subsystem name (the subsystem needs to be set up by an MVS system
administrator) and retrieves the table and index definitions for the named
table.  Execution is invoked by:

describe tablename

The named table is owned by the currently logged on user; in effect what
the utility does is describe qualifier.tablename.

Any SQL errors produced during execution are written to standard output.
Full SQL error message output (SQLCODE, SQLSTATE and text messages) is
provided in the event that an SQL error occurs.

The definition for the table lists all columns and their datatypes.  The
lengths of CHAR and VARCHAR types are also provided.  Any indexes
associated with the table will also be listed.  Indexes are comprised of
the index name, the list of columns - in the order in which they were
specified when the index was created - in parentheses and the index type
(primary key, unique, etc.)