Example 1: The following statement sets the CURRENT SCHEMA special register.
SET SCHEMA = RICK
Example 2: The following example retrieves the current value of the CURRENT SCHEMA special register into the host variable called CURSCHEMA.
EXEC SQL VALUES(CURRENT SCHEMA) INTO :CURSCHEMA
The value would be RICK, set by the previous example.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.