Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

SHOW-CATID-LIST

This statement displays the current CATID list.

Scope of validity

DBH administration

Function

The administration statement SHOW-CATID-LIST outputs the current CATID list.

The following is displayed:

  • file name of the CATID list used last

  • the current CATIDs.

SHOW-CATID-LIST

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


<structured-name 1..20>(...)



|

WRITE-MODE = *REPLACE / *EXTEND

Operands

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

catalog identifier

var(*LIST).CATID

S

<cat-id 1..4>


Example

Output to the screen after entering the SHOW-CATID-LIST administration statement:

%SHOW-CATID-LIST
FILE :5OC1:$SQLDB112.WIE.CATIDS C
------------------------------------------------------------------
5OC1 ! 5OC2 ! 5OC3 ! 5OC4 ! 5OC5 ! 50C6 ! 50C7 ! 50C8 ! 50C9 ! 50CA
   S !    T !  AB3 !   C4 !    X ! 1OSQ ! 3OSQ ! 4OSQ !      ! 
% <date> <time> SES7215 END OF OUTPUT 
%// 


Administration command in ISP format and at the CALL DML interface

The INF,C administration command corresponds to the SHOW-CATID-LIST administration statement here.

INF,C[id-list]