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;
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.