Cluster Specification (Adabas only)

A cluster specification is used to identify a table cluster in a user session.

 

cluster_identifier.bmp

 

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

If no default has 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 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.