Declare a host variable

Declare host variables for database columns of type CLOB or BLOB as a fixed binary host variable with the ifx_lo_t structure (called an ifx_lo_t data type) as follows:

EXEC SQL include locator;
⋮

EXEC SQL BEGIN DECLARE SECTION;
   fixed binary 'clob' ifx_lo_t clob_loptr;
   fixed binary 'blob' ifx_lo_t blob_loptr;
EXEC SQL END DECLARE SECTION;
⋮

EXEC SQL select blobcol into :blob_loptr from tab1;