Examples

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.