How to Save a Set of Commands as a Qfile › Using One Qfile to Create Different Reports › Step 3 - Resume Qfile execution

Step 3 - Resume Qfile execution

In this step, you resume execution of the qfile to apply new data retrieval selection criteria.

The final report displays only those employees in salary grades of 16 or higher.

Select Yes to continue data retrieval.

     CA OLQ Release nn.n                           *** Retrieval Interrupted ***
 ->
131000 Select YES or NO and press the ENTER key

         Retrieval interrupted due to excessive data base accesses.


 Number of whole rows. . . . . . . .       48
 Total number of records read. . . .      100
 Total number of records selected. .       87
 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

Depending on how high the interrupt count at your site is set, CA OLQ may bypass the Retrieval Interrupted screen and proceed directly to the Retrieval Completed screen.

     CA OLQ Release nn.n                         *** Retrieval Completed ***
 ->
130000 Select activity and press the ENTER key


 Number of whole rows. . . . . . . .       59  Total displayable cols .      20
 Total number of records read. . . .      125  Formatted line length. .     372
 Total number of records selected. .      106
 Number of data errors . . . . . . .        0

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

       X        Display report                             DISplay
       _        Save report                                SAVe
       _        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

     CA OLQ Release nn.n                              *** Display Report ***
 ->                                                       Page     1 Line     1
125000 Press the ENTER key to go to the next page of the report.

                           EMPLOYEE/EMPOSITION REPORT
                                    mm/dd/yy

   FIRST         LAST                                  SAL.          BONUS
   NAME          NAME       START       GRADE         AMOUNT           %
 ────────── ─────────────── ───── ── ── ───── ────────────────────── ─────
 HERBERT    LIPSICH            04 29 81    21               18500.00  .004
 MICHAEL    ANGELO             09 08 79    21               18000.00  .004
 RALPH      TYRO               12 21 80    21               20000.00  .004
 MICHAEL    ANGELO             09 08 79    21               17000.00  .004
 DOUGLAS    KAHALLY            09 29 79    21               20000.00  .004
 CAROL      MCDOUGALL          06 07 80    21               18000.00  .004
                                                         ───────────
                                              AVE FOR 21:   18583.33

 JANE       FERNDALE           09 09 79    22               22500.00  .004


                                      - 1 -
 1=HELP     3=QUIT     4=MESSAGE     6=MENU     8=FWD     10=LEFT     11=RIGHT