A table specification is used to identify a base table or viewed table (view) in a user session.

 

 

If catalog_identifier is omitted, the default catalog for the current session is used.  

If a default catalog hasn't been 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 hasn't been 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.