SQL$HELP72.HLB  —  DESCRIBE  Arguments  SELECT_LIST
    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).
Close Help