REMOVE-SQL-DB-CATALOG-ENTRY

This statement removes an entry from the SQL database catalog.

Scope of validity

DBH administration

See also

• DBH start statement ADD-SQL-DATABASE-CATALOG-LIST on "ADD-SQL-DATABASE-CATALOG-LIST"

• DBH option SQL-DATABASE-CATALOG on "SQL-DATABASE-CATALOG"

Function

The REMOVE-SQL-DB-CATALOG-ENTRY statement removes the entry for a database from the SQL database catalog.

The database must not be active. The REMOVE-SQL-DB-CATALOG-ENTRY administration statement is only executed when the database has a not ACTIVE status.

REMOVE-SQL-DB-CATALOG-ENTRY

SELECT = *LOGICAL(...) / *PHYSICAL(...)
	*LOGICAL(...)
		|	CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
	*PHYSICAL(...)
		|	PHYS-CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>

Operands

SELECT =

Specifies the database name that identifies the entry to be removed.

SELECT = *LOGICAL(...)
Causes the entry with the specified logical database name to be removed.

CATALOG-NAME =
<filename 1..18 without-cat-user-gen-vers>
Logical name of the database whose entry is to be removed from the SQL database catalog

SELECT = *PHYSICAL(...)
Causes the entry with the specified physical database name to be removed.

PHYS-CATALOG-NAME =
<filename 1..18 without-cat-user-gen-vers>
Physical name of the database whose entry is to be removed from the SQL database catalog

Administration command in ISP format and at the CALL DML interface

The OPT,DBC-DEL administration command corresponds to the REMOVE-SQL-DB-CATALOG-ENTRY administration statement here.

OPT,DBC-DEL,supplement

supplement ::= {C[ATALOG]=catalog-name|P[HYSICAL-NAME]=physical-name}