In a C program, execute a DESCRIBE statement with an SQLDA that has no occurrences of SQLVAR. If SQLD is greater than zero, use the value to allocate an SQLDA with the necessary number of occurrences of SQLVAR and then execute a DESCRIBE statement using that SQLDA.
EXEC SQL BEGIN DECLARE SECTION; char table_name[201]; EXEC SQL END DECLARE SECTION; EXEC SQL INCLUDE SQLDA; EXEC SQL DECLARE DYN_CURSOR CURSOR FOR STMT1_NAME; .../*code to prompt user for a table or view */ .../*code to set SQLN to zero and to allocate the SQLDA */ EXEC SQL DESCRIBE TABLE :table_name INTO :sqlda; ... /* code to check that SQLD is greater than zero, to set */ /* SQLN to SQLD, then to re-allocate the SQLDA */ EXEC SQL DESCRIBE TABLE :table_name INTO :sqlda; . . .
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.