Description
- schema-name
- Identifies a schema. No validation that the schema exists is made at
the time the CURRENT SCHEMA is set.
If the value specified does
not conform to the rules for a schema-name, an error is returned.
- SESSION_USER or USER
- This value is the SESSION_USER special register.
- SYSTEM_USER
- This value is the SYSTEM_USER special register.
- variable
- Specifies a variable which contains a schema name. The content
is not folded to uppercase.
The variable:
- Must be a character-string or Unicode graphic variable. The
actual length of the contents of the variable must not exceed the
length of a schema name. See Appendix A. SQL limits.
- Must not be followed by an indicator variable.
- Must include a schema that is left justified and must conform to the rules
for forming an ordinary or delimited identifier.
- Must be padded on the right with blanks if the variable is fixed length.
- Must not be the null value.
- Must not be the keyword SESSION_USER, SYSTEM_USER, or USER.
- string-constant
- A character or Unicode graphic constant with a schema name.
- DEFAULT
- The CURRENT SCHEMA is set to its initial value. The initial value for
SQL naming is USER. The initial value for system naming is *LIBL.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.