Home SELCOPY CBLVCAT CBLi Trial/Prices CBL SiteMap
 
VSAM File Tuning, ICF/VSAM Catalog Reporting, VTOC Display and Modification

CBLVCAT Examples Menu

Customising the report can be very useful, for example:

  1. Reporting only the information you require.
  2. Reporting information not contained in the standard report.

The example below is for an ICF catalog, but it should be noted that the REPORT operation can also be used on VSAM catalogs and VTOCs.

If for instance you want to know which files contain the most records then searching through the full report can be tedious. Obtaining only the information you require is Quick and Easy with the Customised Report facility.

 ___________________________________________________________________________________
|                                                                                  /
|   CBLVCAT REL 2.10 AT COMPUTE (Bridgend) Ltd - Wales    2003/09/26  PAGE   1     \
| o --------------------------------------------------    ----------  --------     /
|                                                                                  \
|         REPORT   VCAT               DSN   SORTD NRECS  TYPE                      /
| o                                                                                \
|         LISTCAT  REF=WXYZ.NRECS1   NOINDEX                                       /
|                                                                                  \
| o                                                                                /
|   ICF CAT CBLI94 (3380)                            NRECS  TYPE                   \
|   ---------------------                            -----  ----                   /
| o                                                                                \
|   LOTS.NRECS1                                      62828  KSDS                   /
|   ABCD.NRECS1                                      61430  KSDS                   \
| o WXYZ.NRECS1                                      57809  KSDS                   /
|   LESS.NRECS1                                      57784  KSDS                   \
|   ABCD.123.LESS.NRECS                               7500  RRDS                   /
| o SMALLER.NRECS.123                                 2250  RRDS                   \
|   LAST.SHOWN.NRECS.12                               1323  KSDS                   /
|/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\\

Notes:

The REPORT command is used to define the format of the report, in this example the three fields requested are the Dataset name (DSN), the number of records for that file (NRECS) and the file type (TYPE).

The positional SORTD parameter invokes a descending sort of output based on the keywords that follow it, in this case NRECS and TYPE, giving a sort on the number of records and type.

The REF=WXYZ.NRECS1 parameter is used to identify the required catalog, instead of supplying a DD card for the catalog itself and using DDNAME. The DSN supplied may be the catalog dataset name, an alias or the name of any file contained within the catalog. Thus you need only know the name of one file within the catalog, CBLVCAT will do the rest.

The NOINDEX parameter causes the index lines to be suppressed for KSDS and AIX files.

The user can select from 59 Catalog and 15 VTOC items to build reports of varying complexity. See the Advanced Customised Reporting example later in the brochure.

Top © 2005 Compute (Bridgend) Limited
http://www.cbl.com/cblvex04.html
2006-09-13 14:50