It is possible to process LONG columns from SQL-PL. The descriptor provided by the DBMS for the OPEN statement (see ADABAS Reference Manual) must be specified in subsequent READ, WRITE, and CLOSE statements to identify the LONG column.
Examples: Operations on LONG columns
OPEN and READ of a LONG column can also be combined into the faster FREAD. The FREAD statement opens the LONG column in the same way as the OPEN statement and makes the contents of the LONG column available in the specified buffer, starting with the first position.
Example:
A complete description of the processing of LONG columns is contained in the ADABAS Reference Manual.
Syntax:
The complete syntax of SQL statements for manipulating LONG columns is to be found in the ADABAS Reference Manual.
See also
Dynamic Opening of LONG Columns