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