DB2 Version 9.7 for Linux, UNIX, and Windows

DEFINE_COLUMN_NUMBER procedure - Define a DECFLOAT column in the SELECT list

The DEFINE_COLUMN_NUMBER procedure defines a DECFLOAT column or expression in the SELECT list that is to be returned and retrieved in a cursor.

Syntax


>>-DBMS_SQL.DEFINE_COLUMN_NUMBER--(--c--,--position--,--column--)-><

c: An input argument of type INTEGER that specifies the cursor handle associated with the SELECT command.
position: An input argument of type INTEGER that specifies the position of the column or expression in the SELECT list that is being defined.
column: An input argument of type DECFLOAT.

EXECUTE privilege on the DBMS_SQL module.