DB2 Version 9.7 for Linux, UNIX, and Windows

DESCRIBE statement

The DESCRIBE statement obtains information about an object. There are two types of information that can be obtained with this statement. Each of these is described separately.
  • Input parameter markers of a prepared statement. Gets information about the input parameter markers in a prepared statement. This information is put into a descriptor.
  • The output of a prepared statement. Gets information about a prepared statement or information about the select list columns in a prepared SELECT statement. This information is put into a descriptor.