Table Specification
A table specification is used to identify a base table or viewed table (view) in a user session.
Syntax:
[catalog_identifier].[schema_identifier].[table_identifier]
If catalog_identifier is omitted, the default catalog for the current session is used. If a default catalog is not set via the SET CATALOG statement, CONNX attempts to match the table identifier against all available catalogs in the data dictionary. If more than one match is found across multiple catalogs, an error is returned.
If schema_identifier is omitted, the default schema for the current session or user is used. If a default schema is not set for either the current session via the SET SCHEMA statement, or for the current user during the CREATE USER statement, CONNX attempts to match the table identifier against all available schemas in the data dictionary. If more than one match is found across multiple schemas, an error is returned.