Chapter 9 SQL Statements
535
GET DATA statement [ESQL]
Use this statement to get string or binary data for one column of the current
row of a cursor. GET DATA is usually used to fetch LONG BINARY or
LONG VARCHAR fields. See "SET statement" on page 605.
GET DATA
cursor-name
… COLUMN
column-num
… OFFSET
start-offset
… [ WITH TEXTPTR ]
… USING DESCRIPTOR
sqlda-name
| INTO
host-variable
[, … ]
cursor-name
:
identifier
, or
host-variable
column-num
:
integer
or
host-variable
start-offset
:
integer
or
host-variable
sqlda-name
:
identifier
The cursor must be opened and positioned on a row, using FETCH.
None.
"FETCH statement" on page 523
"READTEXT statement" on page 587
Get a piece of one column value from the row at the current cursor position.
COLUMN clause The value of column-num starts at one, and identifies
the column whose data is to be fetched. That column must be of a string or
binary type.
OFFSET clause The start-offset indicates the number of bytes to skip
over in the field value. Normally, this would be the number of bytes
previously fetched. The number of bytes fetched on this GET DATA
statement is determined by the length of the target host variable.
The indicator value for the target host variable is a short integer, so it cannot
always contain the number of bytes truncated. Instead, it contains a negative
value if the field contains the NULL value, a positive value (NOT
necessarily the number of bytes truncated) if the value is truncated, and zero
if a non-NULL value is not truncated.
WITH TEXTPTR clause If the WITH TEXTPTR clause is given, a text
pointer is retrieved into a second host variable or into the second field in the
SQLDA. This text pointer can be used with the Transact-SQL READ TEXT
and WRITE TEXT statements. The text pointer is a 16-bit binary value, and
can be declared as follows:
DECL_BINARY( 16 ) textptr_var;
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
To Next Page
Loading...