The COLUMN_VALUE_TIMESTAMP procedure defines a variable
that will receive a TIMESTAMP value from a cursor.
Syntax
>>-DBMS_SQL.COLUMN_VALUE_TIMESTAMP--(--c--,--position--,--value-->
>--+---------------------------------------+--)----------------><
'-,--column_error--+------------------+-'
'-,--actual_length-'
Parameters
- c
- An input argument of type INTEGER that specifies the cursor ID
of the cursor that is returning data to the variable being defined.
- position
- An input argument of type INTEGER that specifies the position
of the returned data within the cursor. The first value in the cursor
is position 1.
- value
- An output argument of type TIMESTAMP that specifies the variable
receiving the data returned by the cursor in a prior fetch call.
- column_error
- An output argument of type INTEGER that returns the SQLCODE, if
any, associated with the column.
- actual_length
- An output argument of type INTEGER that returns the actual length
of the data, before any truncation.
Authorization
EXECUTE privilege on the DBMS_SQL
module.
DB2 Version 9.7 for Linux, UNIX, and Windows