How to Save a Set of Commands as a Qfile › Modifying Your Qfile Definition › Step 1 - Establish a current report

Step 1 - Establish a current report

In this step, you execute the SALARY qfile to create a current report. Start on the Qfile Processing screen. To get there type qfile in the command line of any screen.

Select Execute and select the SALARY qfile.

      CA OLQ Release nn.n                          *** QFILE Processing ***
  ->                                                       Page     1 of     1
 140000 Select function and press the ENTER key

  User: SYB
  Dictionary name: TSTDICT                      Dictionary node:

  Function:    x Execute       _ Create         _ Replace       _ Delete
               _ Execute with new criteria      _ List          _ Edit
               _ Execute batch

  Routine name:                                   Version:
  Comments:

  SELECT ROUTINE                   VERSION  COMMENTS
  _  DEPARTMENT                          1
  _  MANAGERS                            1
  _  NEW EMPLOYEES                       1
  _  SALARY GRADE                        1 SALARY SUMMARY COMPUTATIONS
  x  SALARY                              1 EXAMPLE



  1=HELP                 3=QUIT                 4=MESSAGE                 6=MENU

Specify Yes to continue data retrieval.

    CA OLQ Release nn.n                            *** Retrieval Interrupted ***
 ->
192018 The default DICTNAME value has been modified.
092027 Underline character has been modified to -
         Retrieval interrupted due to excessive data base accesses.


 Number of whole rows. . . . . . . .       54
 Total number of records read. . . .      100
 Total number of records selected. .       99
 Number of data errors . . . . . . .        0



         Continue execution     x Yes
                                X No


         Current interrupt interval is     100 data base accesses.




 1=HELP                            3=QUIT                            4=MESSAGE

Specify that you want to proceed to the Report Format – Sort screen.

      CA OLQ Release nn.n                     *** Retrieval Completed ***
  ->
 105022 Sort successfully completed.  68 records in.  68 records out.
 092021 Execution has completed for q-file: SALARY

  Number of whole rows. . . . . . . .       68
  Total number of records read. . . .      125
  Total number of records selected. .      124
  Number of data errors . . . . . . .        0

      Select                                                 Command/
      Option     ---> Display/Format Activity <---          Screen Name

        X        Display report                             DISplay
        _        Save report                                SAVe
        x        Choose the sort sequence of report         SORt
        _        Change column headers                      HEAder
        _        Change page header and footer              PAGe HEAder
        _        Change display format of data ($,commas)   PICture
        _        Format columns (Alignment, sparse)         EDIt
        _        Specify summary computations (Totals)      GROup BY
        _        Send the report to a printer               PRInt

  1=HELP                 3=QUIT                 4=MESSAGE                 6=MENU