Definitions Exclusive to Adabas
Table Name Definition
CONNX creates a base table for each Adabas database. The base table is not part of a table cluster.
Syntax:
TABLE_SPECIFICATION [DATABASE database_identifier | DATABASE NUMBER database_number]
If database_number or database_identifier is omitted, CONNX uses the Adabas database identified by the catalog identifier (if provided) in the table specification. The specified Adabas database must be accessible for the SQL gateway.
Cluster Specification
A cluster specification is used to identify a table cluster in a user session.
Syntax:
[catalog_identifier] [.] [schema_identifier] [.] [cluster_identifier]
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.
Cluster Name Definition
A table cluster is created in relation to a specific Adabas database.
Syntax:
CLUSTER_SPECIFICATION [DATABASE database_identifier | DATABASE NUMBER database_number]
If database_number or database_identifier is omitted, CONNX uses the Adabas database identified by the catalog identifier (if provided) in the table specification. The specified Adabas database must be accessible for the SQL gateway.
File Definition
Some Adabas file parameters can be specified when creating an Adabas file using a CREATE TABLE or a CREATE CLUSTER statement.
Syntax:
where:
adabas_file_number | If specified, it has to be unused. If not, Adabas will choose a free one. |
max_isn | The following identifiers are recognized: ADABAS_MAXISN |
size_value | The following identifiers are recognized: ADABAS_DSSIZE ADABAS_NISIZE ADABAS_UISIZE By default, SIZE is specified in bytes. 'K' multiplies this value by 1024, 'M' multiplies this value by 1048576. |
unit_param | The following identifiers are recognized: ADABAS_DSUNIT ADABAS_NIUNIT ADABAS_UIUNIT 0 = Default (Bytes) 1 = Blocks 2 = Bytes 4 = Megabytes |
reuse_param | The following identifiers are recognized: ADABAS_REUSE 0 = Default (REUSEISN YES) 1 = REUSEISN NO 4 = REUSEISN YES |
Please refer to the Adabas documentation for details about these parameters and information about their default values.
