1.1.9 Schema path

When a routine name, index type name, or user-defined type that is not qualified explicitly with an authorization identifier is to be searched, a schema path determines the order in which different schemas are searched.

In the case of an index type name or a user-defined type name, if the target schema does not contain an index type name or a user-defined type name, the next schema is searched.

In the case of a function name, if executable candidate functions are not found according to the rules for determining the function to be called, the next schema is searched. For the rules for determining the function to be called, see 2.20 Function calls.

(a) Order of search

Schemas are searched in the following order:

  1. Schemas for the user associated with the default authorization identifier (for the default authorization identifier, see 1.1.8 Qualifying a name)
  2. MASTER schema
(b) Scope of a schema path

In a specification that is not qualified with an authorization identifier, a schema path is applied to the referencing of defined routine names, index type names, and user-defined type names.