INSERT Operation

While performing the insert operation, the field handle is obtained through the USING clause of the EXECUTE statement.

EXEC SQL EXECUTE S1 USING: fld_hdl_buffer;

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

tpe_sqlputdata (

	tpe_get_curtmhdl(),     /* IN transaction handle */

	tpe_get_curdbhdl(),     /* IN db handle          */

	tpe_pcur0,              /* IN cursor             */

	TPE_DT_CHAR,            /*   htypeid             */

	(void *)fld_hdl_buffer, /*    hdl to field       */

	data_buflen,            /* IN bufferlen          */

	fe_offset,              /* IN offset into field  */

	data_buf,               /* IN buffer             */

	&sqlca                  /* OUT sqlca pointer     */

);