The DESCRIBE TABLE statement obtains information about a table or view.
This statement can only be embedded in an application program, SQL function, SQL procedure, or trigger. It is an executable statement that cannot be dynamically prepared. It must not be specified in Java.
Identifies the table or view to describe. When the DESCRIBE TABLE statement is executed:
•The name must identify a table or view that exists at the application server.
•The variable must be a character-string or Unicode graphic-string variable and must not include an indicator variable. It cannot be a global variable.
•The table name that is contained within the variable must be left-justified and must be padded on the right with blanks if its length is less than that of the variable.
•The name of the table must be in uppercase unless it is a delimited name.