You can use the SCLM database contents utility to retrieve information about the project hierarchy from the project database and produce a report. You control the order and format of the data in the report. The utility generates a report that lists the members that match your selection criteria.

This accounting data can then be extracted for members in the database that meet the selection criteria you specify.

The output from the database contents utility can be used as input to other project-defined tools or as input to the SCLM services using the FILE format of FLMCMD.

Figure 1 shows the panel that appears when you select Option 4, Database Contents, from the Utilities panel.

   Menu  SCLM  Utilities  Jobcard  Help
 ──────────────────────────────────────────────────────────────────────────────
                  SCLM Database Contents Utility - Entry Panel
 Command ===>                                                                  

 Selection criteria: (Pattern may be used for Group, Type or Member)
   Project . . : PDFTDEV 
   Group . . . . SBURNF   . . .          . . .         
           . . .          . . .          . . .         
   Type  . . . . *       
   Member  . . . *       

   Enter "/" to select option
   /  Change additional selection criteria
   /  Change customization parameters

 Output control:
                Ex Sub                  Process . . 2  1. Execute
   Messages . . 3  3    1. Terminal                    2. Submit
   Report . . . 3  3    2. Printer
   Tailored . . 3  3    3. Data set     Printer . . H
                        4. None         Volume  . .       
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=Actions  F12=Cancel

The fields on the Database Contents Utility panel are:

Project

The project that you specified on the SCLM Main Menu. An Alternate field also appears if you specified an alternate project.

Group

The groups that are to be reported. Only groups defined to the project definition are allowed.

Type

The name of the type you want processed. Only types defined to the project definition are allowed.

Member

The name of the member you want processed.

Change additional selection criteria

Select this field if you want to change the additional selection criteria. The panel shown in Figure 1 appears when you select this.

If you change additional selection criteria, the changes are carried over from one execution to another. If you do not select this field, and thus do not change the additional criteria, the criteria from the last report are used.

Output control

Specify the destination for messages, reports, and tailored output when they are executed (Ex) or submitted (Sub), by entering the corresponding destination number: 1 for Terminal, 2 for Printer, 3 for Data set, or 4 for None. You cannot select Terminal for both Report and Tailored Output. Similarly, you cannot select None for both Report and Tailored Output. If the tailored output is to be used as input to a tool or to the SCLM services, Data set should be specified for Tailored Output.

If you enter Terminal, Printer, or Data set in the Tailored Output field, the panel shown in Figure 1 appears.

Process

You can call the processing part of the database contents utility from the interactive or batch environment by selecting Execute or Submit, respectively. If you request batch processing by selecting Submit, you must specify the job statement information that is used in the JCL generated for batch processing.

Printer

Specify the printer output class.

Volume

Specify the volume on which SCLM should save data sets.

For information about using a unique jobname on the jobcard in batch processing, see Batch Processing.