This statement inserts entries in the CALL DML table catalog.
Definition
Third DBH start statement
Function
You use the DBH start statement ADD-OLD-TABLE-CATALOG-LIST to supply the CALL DML table catalog with entries. You only have to enter this start statement if CALL DML applications are to run during the DBH session.
You enter in the CALL DML table catalog all the CALL DML tables that the DBH can access during the session. You assign each CALL DML table to a database. You also assign the table name used in the CALL DML Open statement to the name of a base table.
The DBH can use the CALL DML table catalog to assign the CALL DML tables addressed in an application to the appropriate databases.
There must be an entry in the SQL database catalog for each database to which a CALL DML table is assigned (see "ADD-SQL-DATABASE-CATALOG-LIST").
You use the DBH option OLD-TABLE-CATALOG to specify the maximum number of entries permitted in the CALL DML table catalog. Its default value is 0, but you can specify a value of up to 254 (see "OLD-TABLE-CATALOG"). If you enter more databases than the maximum number permitted, an error message appears.
You can enter up to 100 CALL DML tables in a single start statement. If you want to enter more than 100 tables, you have to enter the DBH start statement ADD-OLD-TABLE-CATALOG-LIST as many times as is necessary. However, the total number of all entered CALL DML tables must not exceed the limit value specified by the DBH option OLD-TABLE-CATALOG.
You can also use several ADD-OLD-TABLE-CATALOG-LIST statements to enter the required databases in groups.
You conclude parameter input for ADD-OLD-TABLE-CATALOG-LIST with the END statement. This END statement simultaneously concludes input of all DBH start statements.
You can enter fewer CALL DML tables than specified by the DBH option OLD-TABLE-CATALOG. Free entries can be reserved by means of administration. You can use the ADD-OLD-TABLE-CATALOG-ENTRY administration statement (see "ADD-OLD-TABLE-CATALOG-ENTRY") to enter additional CALL DML tables during the session, but these entries apply only to this session.
ADD-OLD-TABLE-CATALOG-LIST | ||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||
Operands
ENTRY-1 = *NONE
No CALL DML table is entered in the CALL DML table catalog.
ENTRY-1 = *CALL-DML-TABLE(...)
First CALL DML table entered in the CALL DML table catalog
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; i.e. you may enter it only once in a DBH session.
CATALOG-NAME = <filename 1..18_without_all>
Logical name of the database to which the CALL DML table is to be assigned. The logical database name must be entered in the SQL database catalog.
SCHEMA-NAME = <c-string 1..31_with_lowercase> or <text 1..31>
Name of the schema to which the CALL DML table is to be assigned.
TABLE-NAME = <c-string 1..31_with_lowercase> or <text 1..31>
Base table name corresponding to CALL-DML-TABLE-NAME.
ENTRY-2 = *NONE
No further CALL DML table is entered in the CALL DML table catalog at this point.
ENTRY-2 = *CALL-DML-TABLE(...)
Opening line of the second CALL DML table entered in the CALL DML table catalog. The operands of ENTRY-2 are identical to those of ENTRY-1.
You can enter up to 100 CALL DML tables in an ADD-OLD-TABLE-CATALOG-LIST statement. You begin each entry with ENTRY-x = ... where the placeholder x can have any value from 1 to 99. The placeholder “x” must have a different value for each entry. The associated operands in each case are identical to those of ENTRY-1.
ENTRY-100 = *NONE / *CALL-DML-TABLE(...)
Opening line of the 100th CALL DML table entered in the CALL DML table catalog. You cannot enter more than 100 CALL DML tables in one ADD-OLD-TABLE-CATALOG-LIST statement. If you want to include more than 100 CALL DML tables in the session, you have to enter this start statement again.