REMOVE-OLD-TABLE-CATALOG-ENTRY

This statement removes an entry from 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"

• The DBH option OLD-TABLE-CATALOG on "OLD-TABLE-CATALOG"

Function

The REMOVE-OLD-TABLE-CATALOG-ENTRY statement removes an entry from the CALL DML table catalog.

You can use this administration statement to remove either a single CALL DML table from the catalog or all entries assigned to a specific database.

A CALL DML table to be removed from the CALL DML table catalog must not be active. If it is active (i.e. currently being accessed), the DBH rejects the REMOVE-OLD-TABLE-CATALOG-ENTRY administration statement for this table.

REMOVE-OLD-TABLE-CATALOG-ENTRY

SELECT = *SQL(...) / *CALL-DML(...)
	*SQL(...)
		|	CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
	*CALL-DML(...)
		|	CALL-DML-TABLE-NAME = <text 1..17>

SELECT =

Specifies which entries are to be removed from the CALL DML table catalog.

SELECT = *SQL(...)
Removes from the CALL DML table catalog all entries in which a specific CATALOG-NAME is specified.

CATALOG-NAME =
<filename 1..18 without-cat-user-gen-vers>
Logical database name as a criterion for removing the associated entries. Only those CALL DML tables that are not currently active are affected.

SELECT = *CALL-DML(...)
Removes a specific entry from the CALL DML table catalog.

CALL-DML-TABLE-NAME = <text 1..17>
Name of the CALL DML table as a criterion for removing the associated entry. If the table is active, it is not affected.

Administration command in ISP format and at the CALL DML interface

The OPT,CDBC-DEL administration command corresponds to the REMOVE-OLD-TABLE-CATALOG-ENTRY administration statement here.

OPT,CDBC-DEL,{C[ALL-DML-]T[ABLE]=call-dml-table-name|

C[ATALOG]=catalog-name}