Syntax
The GET DATA statement has the following format:
EXEC SQL GET DATA(:col_value = SEGMENT
[, :length_value = SEGMENTLENGTH]
[, :dataend_value = DATAEND])
[WITH MAXLENGTH = maxlength_value;]
col_value
Specifies the variable to which the value from the column is assigned. The maximum length of a long varchar, long nvarchar, or long byte column is 2 GB.
length_value
(Optional) Signed 4-byte integer to which the length of the data segment is assigned when the segment is read. If the MAXLENGTH parameter is specified, the value returned in the SEGMENTLENGTH variable, when the last segment is read, is less than MAXLENGTH . If the MAXLENGTH parameter is omitted, the value returned in the SEGMENTLENGTH variable is either the length of the segment variable or the number of remaining bytes, whichever is smaller.
dataend_value
(Optional) Signed 4-byte integer returns 1 if the segment is the last segment, 0 if the segment is not the last.
maxlength_value
(Optional) Signed 4-byte integer specifying the number of bytes to be returned. This value must not exceed the length of the SEGMENT variable. Maxlength_value can be specified using a literal or a host language variable.
The host language variables for col_value, length_value, dataend_value and maxlength_value must be declared in a BEGIN DECLARE SECTION/END DECLARE SECTION block to the ESQL preprocessor.
If a data handler routine attempts to exit without issuing an ENDDATA statement, the DBMS Server issues a runtime error.