Examples

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

   EXEC SQL VALUES CURRENT PATH
            INTO :HV1;

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, and assign CURRENT TIMESTAMP to the host variable TIMETRACK.

   EXEC SQL VALUES (SUBSTR(:LOB1,1,35), CURRENT TIMESTAMP)
            INTO :DETAILS, :TIMETRACK;