DB2 Version 9.7 for Linux, UNIX, and Windows

COLUMN_VALUE_RAW procedure - Return a RAW column value into a variable

The COLUMN_VALUE_RAW procedure defines a variable that will receive a RAW value from a cursor.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_SQL.COLUMN_VALUE_RAW--(--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 BLOB(32767) that specifies the variable receiving the data returned by the cursor in a prior fetch call.
column_error
An optional output argument of type INTEGER that returns the SQLCODE, if any, associated with the column.
actual_length
An optional output argument of type INTEGER that returns the actual length of the data, before any truncation.

Authorization

EXECUTE privilege on the DBMS_SQL module.