Partially Qualified Table Names

Restriction: This topic applies to Windows environments only.

Partially qualified table names can be one-part or two-part names. A two-part table name consists of the table-identifier qualified by the authid, and implicitly qualified by the location-name of the current location.

A one-part table name consists of the table-identifier only, which is implicitly qualified by the location-name of the current location, and the Current SQLID special register. The value of the Current SQLID special register is determined by the following rules:

For static SQL statements, the Current SQLID is the identifier specified in the QUALIFIER option of the BIND command used to bind the SQL statements, or the owner of the plan or package.
For dynamic SQL statements, the Current SQLID is the identifier contained in the Current SQLID special register -- initially the same as USER, but changing to reflect execution of a SET CURRENT SQLID command. The Current SQLID can also be influenced by security exits and SecondaryID specifications.

Note:

Aliases and synonyms can be used for alternative names for a table or view. Aliases can be used to assign alternative names for tables and views that are not in the current location. Synonyms can only be used to rename tables or views in the current location.