This statement creates a valid reference to a table entry in the CALL DML database catalog.
Scope of validity
DBH administration
See also
Administration statement ADD-OLD-TABLE-CATALOG-ENTRY on "ADD-OLD-TABLE-CATALOG-ENTRY"
Administration statement SHOW-OLD-TABLE-CATALOG-ENTRIES on "SHOW-OLD-TABLE-CATALOG-ENTRIES"
Function
With the REUSE-OLD-TABLE-CATALOG-ENTRY statement, an attempt is made to create a valid reference to a table for an entry in the CALL DML database catalog.
Before this statement is called, the entry addressed must exist in the CALL DML database catalog with the CALL DML table name; otherwise, the statement will be rejected.
The table type is not checked. The user must ensure that only references to tables of the type CALL DML only or CALL DML/SQL are made.
If the table does not exist in the database, an assignment is not possible. The entry continues to have the status “invalid”. If the database is not open at the time of the call, the entry also continues with the status “invalid”.
If you do not specify any CALL DML table name in the call, the action is performed for all entries in the CALL DML database catalog which have the status “invalid”. If no entry has the status “invalid”, the statement is ignored without an error message.
If the call is successful, the entry subsequently takes on the status “valid”. The specified table can now be accessed with CALL DML.
If the call is not successful, the table is not available and thus has the status “invalid”. Subsequent CALL DML statements are rejected with a status message.
If the table is created subsequently with the SQL statement CREATE TABLE, it is initially not yet available for CALL DML. In this case, you must issue the ADD-OLD-TABLE-CATALOG-ENTRY or REUSE-OLD-TABLE-CATALOG-ENTRY administration statement with a corresponding table entry after CREATE TABLE.
REUSE-OLD-TABLE-CATALOG-ENTRY |
CALL-DML-TABLE-NAME = *ALL / <text 1..17> |
Operands
CALL-DML-TABLE-NAME = *ALL / <text 1..17>
Name of the CALL DML table (maximum 17 positions). If the default value *ALL is specified, an attempt is made to create a valid reference for all table entries in the CALL DML database catalog.
Administration command in ISP format and at the CALL DML interface
The OPT,CDBC-REUSE administration command corresponds to the REUSE-OLD-TABLE-CATALOG-ENTRY administration statement here.
OPT,CDBC-REUSE[,C[ALL-DML-]T[ABLE]=call-dml-table-name]
call-dml-table-name must not contain any commas as characters because commas function as separators.