When the DESCRIBE TABLE statement is executed, the database manager assigns values to the variables of the SQL descriptor or SQLDA as follows:
When the DESCRIBE statement is executed, the database manager assigns values to the variables of the SQLDA as follows:
The seventh byte is set based on the column described:
The seventh byte is set to the space character if there is not enough room in the SQLDA to contain the description of all columns.
The eighth byte is set to the space character.
If the value of SQLD is n, where n is greater than 0 but less than or equal to the value of SQLN, values are assigned to the first n occurrences of SQLVAR so that the first occurrence of SQLVAR contains a description of the first column of the table, the second occurrence of SQLVAR contains a description of the second column of the table, and so on. For information on the values assigned to SQLVAR occurrences, see Field descriptions in an occurrence of SQLVAR.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.