Specifies that the DESCRIBE statement writes information about
returned values in a prepared statement to the SQLDA. If you
use this clause, the DESCRIBE statement writes information about
the number and data types of any returned values in the prepared
statement to the SQLDA. The program uses that information to
allocate storage for the returned values. The storage allocated
by the program then receives the returned values.
The following statements or clauses return values to the DESCRIBE
statement:
o Select list items in a SELECT statement
o The following statements within multistatement procedures:
- Singleton SELECT statement
- INSERT . . . RETURNING and UPDATE . . . RETURNING statements
- SET assignment statement
o CALL statement (invoking a stored procedure)
o Dynamic singleton SELECT statement
The default is SELECT LIST (or OUTPUT).