The following statement sets the CURRENT PATH special register.
SET PATH = FERMAT, "McDuff", SYSIBM
The following statement retrieves the current value of the SQL path special register into the host variable called CURPATH.
EXEC SQL VALUES (CURRENT PATH) INTO :CURPATH;
The value would be "FERMAT","McDuff","SYSIBM" if set by the previous example.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.