Description
- schema-name
- Identifies a schema. No validation that the schema exists is made at
the time the PATH is set. For example, if a schema-name is misspelled,
it could affect the way subsequent SQL operates. Although not recommended,
PATH can be specified as a schema-name if it is specified as a delimited
identifier.
- SYSTEM PATH
- This value is the same as specifying the schema names "QSYS","QSYS2".
- SESSION_USER or USER
- This value is the SESSION_USER special register.
- SYSTEM_USER
- This value is the SYSTEM_USER special register.
- CURRENT PATH
- Specifies the value of the CURRENT PATH special register
before the execution of this statement. CURRENT PATH is not allowed if the
current path is *LIBL.
- variable
- Specifies a variable that contains one or more schema names that are
separated by commas.
The variable:
- Must be a CHAR, VARCHAR, Unicode GRAPHIC, or Unicode VARGRAPHIC
variable. The actual length of the contents of the variable must not exceed the maximum length of a path.
- Must not be followed by an indicator variable.
- Must not be the null value.
- The list of schema names must be left justified and each schema name conform
to the rules for forming an ordinary or delimited identifier.
- Each schema name must not contain lowercase letters or characters that
cannot be specified in an ordinary identifier.
- Must be padded on the right with blanks if the variable is fixed length
character.
- string-constant
- A character constant with one or more schema names that are separated
by commas.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.