SHOW-OLD-TABLE-CATALOG-ENTRIES

Displays the entries in 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"

• Administration statement REUSE-OLD-TABLE-CATALOG-ENTRY on "REUSE-OLD-TABLE-CATALOG-ENTRY"

Function

The SHOW-OLD-TABLE-CATALOG-ENTRIES statement displays the entries in the CALL DML table catalog. The following appears for each entry:

• the name of a CALL DML table (call dml table)

• the logical name of the database to which the CALL DML table is assigned (catalog name)

• the name of the schema to which the CALL DML table is assigned (schema name)

• the name of the base table to which the CALL DML table is assigned (table name)

• the status of the entry:

valid: 

When analyzing the entry, an assignment to a CALL DML table was detected;

this assignment still exists.

invalid:
When analyzing the entry, either no assignment to an existing table could be found or this assignment has been lost again. This situation occurs in the following cases:

• • • The database has either been closed again in the meantime (by means of the SET-CATALOG-STATUS administration statement, for example) or was not open when the entry was analyzed.
    • The table to which the assignment is to be made is not known (or no longer known) in the database (e.g. because DROP TABLE was issued for the
      table, for example).

SHOW-OLD-TABLE-CATALOG-ENTRIES

SELECT = *ALL / *SQL(...) / *CALL-DML(...)
	*SQL(...)
		|	CATALOG-NAME = <filename 1..18 without-cat-user-gen-vers>
	*CALL-DML(...)
		|	CALL-DML-TABLE-NAME = <text 1..17>
,STRUCTURE-OUTPUT = *NONE / *SYSINF / <structured-name 1..20>(...)
	<structured-name 1..20>(...)
		|	WRITE-MODE = *REPLACE / *EXTEND

Operands

SELECT =

Specifies which entries in the CALL DML table catalog are to be displayed.

SELECT = *ALL
Specifies that all entries in the CALL DML table catalog are to be displayed.

SELECT = *SQL(...)
Specifies that those entries containing a specific CATALOG-NAME are to be displayed.

CATALOG-NAME =
<filename 1..18 without-cat-user-gen-vers>
Logical database name that functions as a criterion for displaying the associated entries

SELECT = *CALL-DML(...)
Specifies that only the entry containing the specified CALL-DML-TABLE-NAME is to be displayed.

CALL-DML-TABLE-NAME = <text 1..17>
Name of the CALL DML table whose entry is displayed

STRUCTURE-OUTPUT = *NONE / *SYSINF / <structured-name 1..20>

(WRITE-MODE = *REPLACE / *EXTEND)

In S procedures, specifies whether the information is to be output in S variables (see section “Syntax for output in S variables”).

Output in S variables

Output information	Name of the S variable	T	Contents
Name of the CALL DML table	var(*LIST).CALL-DML-TABLE	S	<text 1..17>
Logical database name	var(*LIST).CATALOG	S	<filename 1..18>
Schema name	var(*LIST).SCHEMA	S	<text 1..31>
Name of the base table	var(*LIST).TABLE	S	<text 1..31>
Status of the entry	var(*LIST).STATE	S	VALID / INVALID

Example

Output to the screen after entering the SHOW-OLD-TABLE-CATALOG-ENTRIES administration statement:

%SHOW-OLD-TABLE-CATALOG-ENTRIES
<call-dml-table> |<catalog-name>     |<schema-name> / <table-name>    |<status> 
-------------------------------------------------------------------------------
DB6LOKG          |DB6LOKG            |SCHEMA112                       | valid   
                 |                   |TAB112                          | 
% <date> <time> SES7215 END OF OUTPUT 
%// 

Administration command in ISP format and at the CALL DML interface

The OPT,CDBC-INFO administration command corresponds to the SHOW-OLD-TABLE-CATALOG-ENTRIES administration statement here.

OPT,CDBC-INFO[,supplement]

supplement :: = {C[ATALOG]=catalog-name|

C[ALL-DML-]T[ABLE]=call-dml-table-name}

If you do not specify the supplement parameter, the whole CALL DML table catalog is displayed.