How to Make a Report from a Table › Creating Your Report From an ASF Table › Step 5— Retrieve the data

Step 5— Retrieve the data

When you are retrieving the data for your report, two CA OLQ screens help you monitor what's going on.

The Retrieval Interrupted screen

This screen indicates that your report will contain more records than the current interrupt count allows.

Note: This screen is here just to show you an example. The numbers on the screen do not reflect the numbers you will encounter in this example.

Specify 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. . . . . . . .       46
 Total number of records read. . . .      100
 Total number of records selected. .       46
 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

What is an interrupt count?

The interrupt count indicates how many records are retrieved from the database at a time. It serves as a testing feature when you are designing your report, enabling you to create the report format that you want without retrieving more data than you need to.

Changing the interrupt count

The interrupt count is set at system generation. You can change this value by using the Interrupt Count option on the Retrieval Interrupted screen, or on the Session Options screen.

What to do

If the number of records that meet the criteria for your report exceeds the interrupt count, the Retrieval Interrupted screen asks you whether you want to continue data retrieval:

• If you want to continue retrieval select the Yes function on the screen. CA OLQ will continue to retrieve more records until the interrupt count is met again, or until all of the records that meet the criteria for your report have been retrieved.
• If you want to terminate retrieval select the No function on the screen. CA OLQ will create a report that contains only those records that have been retrieved up to this point.

The Retrieval Completed screen

This screen indicates that retrieval is completed for your report. From here you can either display your report or select one of the report formatting or print options from the menu on the screen.

In this example, only six records are retrieved for your report. Since this is less than the current interrupt count, you bypass the Retrieval Interrupted screen and go straight to the Retrieval Completed screen.

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


 Number of whole rows. . . . . . . .        6  Total displayable cols .      20
 Total number of records read. . . .        6  Formatted line length. .     372
 Total number of records selected. .        6
 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