This statement adds an entry to the CALL DML table catalog.
Scope of validity
DBH administration
See also
DBH start statement ADD-OLD-TABLE-CATALOG-LIST on "ADD-OLD-TABLE-CATALOG-LIST"
DBH start statement ADD-SQL-DATABASE-CATALOG-LIST on "ADD-SQL-DATABASE-CATALOG-LIST"
DBH option OLD-TABLE-CATALOG on "OLD-TABLE-CATALOG"
Function
The ADD-OLD-TABLE-CATALOG-ENTRY statement adds an entry to the CALL DML table catalog.
You can only use this administration statement to add a new entry if there is a free entry in the CALL DML table catalog. If the CALL DML table catalog is full, the administration statement is rejected and an error message appears.
The logical database to which you want to assign the CALL DML table must be entered in the SQL database catalog. You can use the SHOW-SQL-DB-CATALOG-ENTRIES administration statement to check this. If the logical database name does not exist, the CALL DML table you want to enter cannot be accessed. The CALL DML table remains inaccessible even if you add the logical database name subsequently, using the ADD-SQL-DB-CATALOG-ENTRY administration statement or the CREATE-CATALOG statement, for example.
The CALL DML table name must be unique (even if a replication is involved); in other words, this name must not already exist in the CALL DML table catalog.
SESAM/SQL does not check whether the CALL DML table you want to enter really does exist. Neither does it check whether the table is accessible to CALL DML.
If the CALL DML table is not available after the administration statement is accepted, all subsequent CALL DML Open statements are rejected and the status indicated. If you then use the SQL statement CREATE TABLE to create the appropriate CALL DML table subsequently, it will only be accessible to CALL DML when you create a valid reference to an existing entry using the REUSE-OLD-TABLE-CATALOG-ENTRY administration statement.
ADD-OLD-TABLE-CATALOG-ENTRY |
CALL-DML-TABLE-NAME = <text 1..17> ,CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers> ,SCHEMA-NAME = <c-string 1..31 with-lower-case> ,TABLE-NAME = <c-string 1..31 with-lower-case> |
Operands
CALL-DML-TABLE-NAME = <text 1..17>
Name of the CALL DML table, as used in the CALL-DML Open statement. You must enter this name in full (17 characters) . It must be unique, even if a replication is involved.
CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
Logical name of the database to which the CALL DML table is to be assigned. This name must be entered in the SQL database catalog.
SCHEMA-NAME = <c-string 1..31 with-lower-case>
Name of the schema to which the CALL DML table is to be assigned.
TABLE-NAME = <c-string 1..31 with-lower-case>
Base table name corresponding to CALL-DML-TABLE-NAME.
Administration command in ISP format and at the CALL DML interface
The OPT,CDBC-INS administration command corresponds to the ADD-OLD-TABLE-CATALOG-ENTRY administration statement here.
OPT,CDBC-INS,C[ALL-DML-]T[ABLE]=call-dml-table-name
,C[ATALOG]=catalog-name
,S[CHEMA]=schema-name
,T[ABLE]=table-name
call-dml-table-name, catalog-name, schema-name andtable-name must not contain any commas, since commas act as delimiters.
If you conclude the OPT,CDBC-INS administration command with a comma, the DBH expects more entries for it.
To ensure these are assigned correctly, you must always include the parameter CALL-DML-TABLE=call-dml-table-name with them!
If you want the DBH to execute the administration command, you must not conclude it with a comma. If you conclude an administration command with a comma and follow it with another administration command, the DBH does not execute the first of the two commands and an error message appears.
When an input takes place via INFORM-PROGRAM, lower case is automatically converted to upper case. Consequently if schema-name or table-name in the catalog contain lower case letters, no usable CDBC entry is created when input is made via INFORM-PROGRAM.