Obtains information about dynamic parameter markers in a prepared dynamic SQL statement and stores that information in a SQLDA structure.
exec sql describe input statement_name using descriptor descriptor_name;
The name of the prepared statement about which you want information. statement_name must identify a prepared statement.
Identifies descriptor_name as an SQLDA structure.
The name of the SQLDA structure that can store information about the dynamic parameter markers in the prepared statement.
...
exec sql prepare s4 from :str4;
exec sql declare c2 cursor for s4;
exec sql describe input s4 using descriptor dinout;
printf(“Number of input parameters is %hd\n”,
dinout.sd.sqld);
Information about the statement is written into the descriptor specified in the using clause. After the get descriptor statement is executed, you can read the information out of the SQLDA structure.
allocate descriptor, deallocate descriptor, describe output, get descriptor, prepare, set descriptor
