How to List Logical View Definitions with a Batch job?

Document ID : KB000019850
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

CA View has a new LIST function using the SARBCH utility. A new SARBCH control statement (LISTVIEW) allows logical views to be listed.

Solution:

CA View has a new LIST function using the SARBCH utility. A new SARBCH control statement (LISTVIEW) allows logical views to be listed.

Logical View Listing Report

The LISTVIEW control statement produces a listing of Logical View definitions which can be for an individual logical view, a group of logical views, or all logical views. The listing is written to the REPORT DD statement in the JCL of the SARBCH utility. (see example below)


    //EXAMPLE1 JOB ACCOUNT,PROGRAMMER 
     //STEP1       EXEC PGM=SARBCH 
     //STEPLIB    DD DSN=CAI.CVDELOAD,DISP=SHR 
     //SYSPRINT DD SYSOUT=* 
     //REPORT    DD SYSOUT=* 
     //SYSIN        DD *  
     /DBASE NAME=VIEW.SYSTEM1 
     /LISTVIEW  VIEW=TESTVIEW*   NUM=001

Format of the control statement:


/LISTVIEW  VIEW=Viewname NUM=Viewnum USER= FILTER= 
where: 
Viewname  is the name of the Logical View.  View names ending in
                    asterisk are treated as a mask and all matching views are listed.

                    Note:           If the View id contains embedded blanks, commas, equal signs, 
                                         parentheses, or quotes, it must be enclosed in quotes (single or double). 
                                         Enter any quotes in the Report-id as a pair of quotes because a non-paired 
                                         quote ends the ID.   
                
                                          For example, if the value is JIM'S REPORT, enter it as 'JIM''S REPORT' or 
                                          "JIM'S REPORT".

Viewnum    is the View Number (1-255)

USER            is a 1-8 character userid for listing private views.  If the user field is omitted 
                    or blank, SARBCH will list the public views.

FILTER          is the Name of the FILTER used in the logical view.  Names ending in asterisk are  
                     treated as a mask and all matching views are listed.  This parameter is used to 
                     produce a Filter to logical view cross-reference listing.

The following Logical View listing is generated by the LIST control statement:

Figure 1