SELECT Operation

For the select from long column, the field handle is obtained using FETCH statement.

EXEC SQL FETCH long_cursor INTO: fld_hdl_buffer;

This field handle is used in the tpe_sqlgetdata () call.

tpe_sqlgetdata (

   tpe_get_curtmhdl(),

   tpe_get_curdbhdl(),

   tpe_pcur0,

   TPE_DT_CHAR,

   (void *)fld_hdl_buffer,

   101,

   fe_offset,

   buffer,

   &fe_val_len,

   &sqlca

);

Refer to "Long Data Type Support" for sample programs that demonstrate the Long data type support in ESQL.