Examples

Example 1: Assign the value of the CURRENT PATH special register to host variable HV1.

   EXEC SQL SET :HV1 = CURRENT PATH;

Example 2: Assume that LOB locator LOB1 is associated with a CLOB value. Assign a portion of the CLOB value to host variable DETAILS using the LOB locator.

   EXEC SQL SET :DETAILS = SUBSTR(:LOB1,1,35);