Managing Started or Scheduled Report Output

This document describes the commands you can use to process the results of started or scheduled reports. It covers the following topics:


Viewing Report Results

The VW or the VX command enables you to view the data accumulated by a history report or a report that has been started or scheduled. The command may be issued from any of the list function screens (LS, LC, LR and LH).

The VW command starts the traditional display program generated in report mode. This module may be (re-) generated when DISPLAY is set to BASIC.

The VX command starts the display program generated in structured mode, using the Software AG Editor. This module may be (re-)generated when DISPLAY is set to EDITOR. The Software AG Editor offers extended functionality for browsing and sorting data.

When you issue the VW command, the display program associated with the report is executed, and the collected data is displayed online.

Start of instruction setTo view report results from the report list screen:

  • Enter the command VW on the selection line preceding the name of a history report or a report that has been started.

    The results of the report appear. An example of report results available using the VW command is shown in the Thread Activity screen below:

    11:22:03                APPLICATION FILE FIELD USAGE                 2020-02-10
                       2020-02-10 11:16:01 - 2020-02-10 11:22:02                   
                                                                         Page:    1
                                 Total        Total         Total                  
    NAT-Appl  File  Fld-Name  Num-of-IOs     Commands      Cmd-Resp                
    -------- ------ -------- ------------- ------------ --------------             
                                                                                   
                  0                      0            1       0.001920             
                 50                      0            3       0.387072             
                 50 OA                   0            3       0.387072             
                 50 OB                   0            3       0.387072             
                 50 OC                   0            3       0.387072             
                 50 OD                   0            3       0.387072             
                 50 OG                   0            3       0.387072             
                 50 OH                   0            3       0.387072             
                 50 OI                   0            3       0.387072             
                 50 OJ                   0            3       0.387072             
                 50 OK                   0            3       0.387072             
                 50 OL                   0            3       0.387072             
                 50 O1                   0            3       0.387072             
                                                                                   
    Command: _____________________________________________________________________ 
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Sort  Exit              --           +                ===>  Menu

    You can scroll forward through the report using the PF8 key. For information on scrolling backwards and forwards through the report data, read Scrolling Through Report Results in Redisplay Mode

When you issue the VX command, the display program associated with the report is executed, and the collected data is displayed online.

Start of instruction setTo view report results from the report list screen:

  • Enter the command VX on the selection line preceding the name of a history report or a report that has been started.

    The results of the report appear. An example of report results available using the VX command is shown in the Thread Activity screen below:

    11:23:44                 APPLICATION FILE FIELD USAGE               2020-02-10
                       2020-02-10 11:16:01 - 2020-02-10 11:23:43    Columns 010 072
    =====>                                                        Scroll ===>  PAGE
     ***** ****************************** top of data *****************************
     00001 -------- ----- -------- ------------ ------------- ------------------- -
     00002                                Total         Total               Total  
     00003 NAT-Appl  File Fld-Name   Num-of-IOs      Commands            CMD-Resp  
     00004 -------- ----- -------- ------------ ------------- ------------------- -
     00005              0                     0            13            0.003250  
     00006              7 LL                  0             2            0.002750  
     00007              7 LM                  0             9            0.054000  
     00008              8 LL                  0             1            0.001375  
     00009              8 LM                  0             1            0.006000  
     00010           1007 LC                  1             2            0.012000  
     00011           1007 LG                  1             2            0.012000  
     00012           1007 LL                  0             6            0.008250  
     00013           1007 LM                  0            18            0.108000  
     00014           1008 LM                 25             9            0.064625  
     00015 ******** ***** ********           27            63            0.272250  
     00016 DAEFONE      0                     0             4            0.001000  
     00017           1007 LM                  0            12            0.072000  
     00018           1008 LL                  0             4            0.005500  
     00019           1008 LM                  0             4            0.024000  
     00020 ******** ***** ********            0            24            0.102500  
     00021 SMART      137 AA                  0             2            0.002250  
     00022            137 AB                  0             2            0.002250  
                                                                                   
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  RVSrt Exit  Updat Rfind       -     +           <===  ===>  Canc

    You can browse the report using Software AG Editor commands, e.g. PF7, PF8 or the main commands TOP, BOT, +, ++, -, --. Enter PF1 to get help about all allowed Editor commands.

Note:
Restrictions apply to the commands that may be issued while viewing reports. For more information, refer to the Command Reference.

Viewing Wide Reports

When reports have more columns than will fit on a screen, PF10 and PF11 may be used to scroll the display to the left or right. When available, these keys are marked with left and right arrows. PF10 scrolls the display to the left, and PF11 scrolls the display to the right. The first column is repeated on each screen.

In mode DISPLAY=EDITOR it is possible for the user to define the output format of fields in a report, e.g. to reduce the output length for a clearly arranged output according to the user’s needs. For more information refer to section Display Programs Using Software AG Editor.

Note:
If you are using an external application, such as a session manager like Software AG's NETPASS, that assigns PF10 and PF11 to functions of the external application, you may have problems viewing report results. If this is the case, you can use PF22 instead to scroll the report results to the left and PF23 instead to scroll the report results to the right.

Viewing Multiple Reports

You can view more than one report. More than one VW or VX command can be entered at a time on the Report Definitions or Started Reports screens. The reports are opened in the order they appear on the report list screen. You can only view them one at a time; the first report must be closed before the next one can be viewed.

Note:
You cannot view multiple history reports. In other words, you cannot issue more than one VW or VX command on the History Reports (LH) screen.

Start of instruction setTo view multiple report results from the report list screen:

  1. Enter the command VW or VXon the selection line preceding the name of more than one report that has been started.

    The results of the first report appear.

  2. When you have finished viewing the results of the first report, press PF3 to close it.

    The results of the second report you selected for viewing appear.

  3. Repeat Step 2 until all reports have been viewed and closed.

Viewing Reports with Numeric Calculation SUM

The numeric field calculation SUM does calculate and display a total of a field´s value.

  • In case this total value exceeds the size of the numeric field display, the total value will be cut from right.

  • In case the field value has digits after the decimal point, these digits will be cut.

  • If digits before the decimal point need to be cut, a K (for 1.000) or M (for 1.000.000) will be printed instead.

Scrolling Through Report Results in Redisplay Mode with the VW Command

When you view report data that spans multiple screens, you can normally only scroll forward through the data. If you need to scroll both backwards and forwards through the data, you must enter redisplay mode.

In redisplay mode, a copy of the most recently-collected data is displayed and is not refreshed until you leave redisplay mode. However, while you are in redisplay mode, Adabas Review continues to collect and summarize data, depending on the report definition and the frequency at which the data for the report changes. So it is possible that the report data you observe in redisplay mode may not match the data you see when you leave redisplay mode.

Note:
After displaying 5000 lines, redisplay mode is disabled for this view.

Start of instruction setTo enter redisplay mode and scroll backward and forward through your report data:

  1. While viewing the report, click PF7 to enter redisplay mode.

    The colors of the report on the screen change.

  2. Use the PF7 and PF8 keys to scroll forward and backward through the report data in redisplay mode.

Start of instruction setTo leave redisplay mode:

  1. Press PF3 to end redisplay mode.

    Redisplay mode ends and the next screen of the report (the screen after the one from which you originally entered redisplay mode) appears. If you were on the last screen of the report when you entered redisplay mode, the first screen of the report appears.

Sorting Report Results

The VIEW/VIEWX command comes with a SORT command that enables you to dynamically change the setting of the "Display By" report option.

The following settings are available within the SORT command:

Setting Sorts the data in . . . Display Option
Account (Ascend) ascending order by control break SORTED
Number of Commands descending order by the "Number of Commands" USAGE
First Summary Field descending order by the first field designated as a summary field in the report definition SUMFIELD
Account (Descend) descending order by control break SORTEDDE
Date and Time ascending order by the start date and time of the control break interval DATETIME
Physical Sequence the physical sequence in which it was collected

Note:
This setting is not available in batch mode.

LINEAR

This section covers the following topics:

Using the SORT Command for the Review Sort

Start of instruction setTo issue the SORT command:

  1. Enter the VW/VX command on the selection line preceding the name of a started report.

  2. From the display of the report results, press PF2. Using VW, you may also enter SORT on the command line.

    A window is displayed, listing the sort options. The option preceded by an arrow (>) is the current sorting sequence report option.

  3. Change the sort option by placing the cursor on your selection and pressing ENTER.

    The order of the data in the display is changed according to the sort option you selected.

Note:
Using VX with the Software AG Editor, you have an additional sort possibility, the Software AG Editor SORT command. This sort operates on the data in the editor area and sorts rows according to specified column and row ranges.

Examples of Sort Options

The "Sample Sort Displays" report example illustrates the differences in data presentation that occur when the SORT command is used with the VIEW/VIEWX command. This example collects and calculates the following statistics on Adabas commands:

Field Statistic Designated as the . . .
15M 15 minute interval in which the command was issued first control break
CMD command code second control break
CMDRESP total response time for the command first summary field
IOS total number of I/Os issued by the command second summary field
COMMANDS total number of commands third summary field
CMDRESP average response time used per command
IOS average number of I/Os issued per command
11:36:34                  A D A B A S  -  R E V I E W                2020-02-10
REVIEW-DB (10,252)               Edit Report                  Hub Target: 296  
                                                                               
Detail/Summary: S   Report Name: SAMPLE SORT DISPLAYS____________   DBID: _____
                                                                               
+-----------------------------------------------------------------------------+
|  Field     Order   Sum   Min   Max   Avg   Pct   Rate      Cost      Round  |
|-----------------------------------------------------------------------------|
| 15M_____    _10     _     _     _     _     _     _     _ ________   ______ |
| CMD_____    _20     _     _     _     _     _     _     _ ________   ______ |
| CMDRESP_    ___     X     _     _     X     _     _     _ ________   ______ |
| IOS_____    ___     X     _     _     X     _     _     _ ________   ______ |
| COMMANDS    ___     X     _     _     _     _     _     _ ________   ______ |
| ________    ___     _     _     _     _     _     _     _ ________   ______ |
| ________    ___     _     _     _     _     _     _     _ ________   ______ |
| ________    ___     _     _     _     _     _     _     _ ________   ______ |
| ________    ___     _     _     _     _     _     _     _ ________   ______ |
| ________    ___     _     _     _     _     _     _     _ ________   ______ |
+-------------------------------- Page 1 --------------------------------------+
                                                                               
                                                                               
Command: ______________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Optns Exit  SOnly Save  Start  -     +    Sched Rules Flds  Menu

The Account (Ascend) Option

Using the "Account (Ascend)" sort option (equivalent to setting the Display By parameter to "SORTED"), the results of the "Sample Sort Displays" report are displayed as follows:

12:40:22                    SAMPLE SORT DISPLAYS                     2020-02-10
                    2020-02-10 12:38:38 - 2020-02-10 12:40:21                   
                                                                        Page: 1
              Total          Total        Total          Avg                   
Time  Cmd    Cmd-Resp     Num-of-IOs     Commands      Cmd-Resp                
----- --- -------------- ------------- ------------ --------------             
                                                                               
20:00 RC        0.005760             0            3       0.001920             
      S1        0.774144             0            6       0.129024             
***** ***       0.779904             0            9       0.086656             
20:15 L3        0.838656             0           12       0.069888             
      RC        0.003840             0            2       0.001920             
      S1        0.774144             0            6       0.129024             
***** ***       1.616640             0           20       0.080832             
***** ***       2.396544             0           29       0.082639             
                                                                               
*****   E N D    O F    R E P O R T   *****                                    
                                                                               
                                                                               
                                                                               
REV00245 - PF-KEY NOT DEFINED                                                  
Command: _____________________________________________________________________ 
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help  Sort  Exit              --           +                ===>  Menu

Data is grouped in ascending order by the first control break, the 15M field. Within the hour group, the data is grouped in ascending order by the second control break, the CMD field.

The Number of Commands Option

Using the "Number of Commands" sort option (equivalent to setting the Display By parameter to "USAGE"), the results of the "Sample Sort Displays" report are displayed as follows:

12:45:20                    SAMPLE SORT DISPLAYS                     2020-02-10
                   2020-02-10 12:38:38 - 2020-02-10 12:45:19                   
                                                                        Page: 1
               Total          Total        Total          Avg
 Time  Cmd    Response         IOs        Commands      Response
 ----- --- -------------- ------------- ------------ --------------
 16:30 N1        0.086016           747          168       0.000512
 16:15 N1        0.232544           540           97       0.002397
 16:30 L6        0.006640           533           24       0.000276
 16:30 ET        0.028688            22           11       0.002608
 16:15 L6        0.036960           261            9       0.004106
 16:15 S1        0.026304             7            3       0.008768
 16:15 ET        0.008320             6            3       0.002773
 ***** ***       0.425472          2116          315       0.001350
 *****   E N D    O F    R E P O R T   *****


 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

Data is grouped in descending order by the "Number of Commands".

Note:
In Adabas Review, COMMANDS is now a selectable field. The "Number of Commands" sort option may be used to sort the display, even if the COMMANDS field is not displayed in the report.

The First Summary Field Option

Using the "First Summary Field" sort option (equivalent to setting the "Display By" parameter to "SUMFIELD"), the results of the "Sample Sort Displays" report are displayed as follows:

12:46:40                    SAMPLE SORT DISPLAYS                     2020-02-10
                   2020-02-10 12:38:38 - 2020-02-10 12:46:40                   
                                                                        Page: 1
               Total          Total        Total          Avg
 Time  Cmd    Response         IOs        Commands      Response
 ----- --- -------------- ------------- ------------ --------------
 16:15 N1        0.232544           540           97       0.002397
 16:30 N1        0.086016           747          168       0.000512
 16:15 L6        0.036960           261            9       0.004106
 16:30 ET        0.028688            22           11       0.002608
 16:15 S1        0.026304             7            3       0.008768
 16:15 ET        0.008320             6            3       0.002773
 16:30 L6        0.006640           533           24       0.000276
 ***** ***       0.425472          2116          315       0.001350
 *****   E N D    O F    R E P O R T   *****


 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

Data is grouped in descending order by the Total Response column, because the CMDRESP field was designated as the first summary field.

The Account (Descend) Option

Using the "Account (Descend)" sort option (equivalent to setting the Display By parameter to "SORTEDDE"), the results of the "Sample Sort Displays" report are displayed as follows:

12:47:19                    SAMPLE SORT DISPLAYS                     2020-02-10
                   2020-02-10 12:38:38 - 2020-02-10 12:47:18                   
                                                                        
                                                                        Page: 1
Total          Total        Total          Avg
 Time  Cmd    Response         IOs        Commands      Response
 ----- --- -------------- ------------- ------------ --------------
 16:30 N1        0.086016           747          168       0.000512
       L6        0.006640           533           24       0.000276
       ET        0.028688            22           11       0.002608
 ***** ***       0.121344          1302          203       0.000597
 16:15 S1        0.026304             7            3       0.008768
       N1        0.232544           540           97       0.002397
       L6        0.036960           261            9       0.004106
       ET        0.008320             6            3       0.002773
 ***** ***       0.304128           814          112       0.002715
 ***** ***       0.425472          2116          315       0.001350
 *****   E N D    O F    R E P O R T   *****

 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

Data is grouped in descending order by the first control break, the 15M field. Within the 15 minute interval, the data is grouped in descending order by the second control break, the CMD field.

The Date and Time Option

Using the "Date and Time" sort option, the results of the "Sample Sort Displays" report are displayed as follows:

12:47:38                    SAMPLE SORT DISPLAYS                     2020-02-10
                   2020-02-10 12:38:38 - 2020-02-10 12:47:37                   
                                                                        Page: 1
Total          Total        Total          Avg
 Time  Cmd    Response         IOs        Commands      Response
 ----- --- -------------- ------------- ------------ --------------
 16:15 N1        0.232544           540           97       0.002397
 16:15 S1        0.026304             7            3       0.008768
 16:15 L6        0.036960           261            9       0.004106
 16:15 ET        0.008320             6            3       0.002773
 16:30 L6        0.006640           533           24       0.000276
 16:30 N1        0.086016           747          168       0.000512
 16:30 ET        0.028688            22           11       0.002608
 ***** ***       0.425472          2116          315       0.001350
 *****   E N D    O F    R E P O R T   *****


 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

Data is grouped in ascending order by the start date and time of the control break interval.

The Physical Sequence Option

Using the "physical sequence" sort option, the results of the "Sample Sort Displays" report are displayed as follows:

12:48:20                    SAMPLE SORT DISPLAYS                     2020-02-10
                   2020-02-10 12:38:38 - 2020-02-10 12:48:19                   
                                                                        Page: 1
Total          Total        Total          Avg
 Time  Cmd    Response         IOs        Commands      Response
 ----- --- -------------- ------------- ------------ --------------
 15:45 L6        0.008064           123           63       0.000128
       E4        0.001344             7            6       0.000224
       E1        0.002880            54           12       0.000240
       RI        0.000800             0           25       0.000032
       CL        0.026160             7            3       0.008720
 ***** ***       0.583040          4188         7553       0.000077
 16:00 S4        0.023760            12          135       0.000176
       A1        0.033968           125          193       0.000176
       ET        0.003040            85           95       0.000032
       L3        0.038560           156          482       0.000080
       RC        0.011296             0          706       0.000016
       L9        0.006912            22          108       0.000064
       S1        0.008832            47           69       0.000128
 Command: _____________________________________________________________________
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Sort  Exit                           +                ===>  Menu

Data is grouped in the order of the physical sequence in which it was collected.

Printing Report Results

The HC command enables you to send report results to a printer, if the hard copy feature of Natural is available. The HC command may be issued from the list of history reports or the list of started or scheduled reports (LH, LS or LC functions).

Start of instruction setTo print report results:

  1. Enter the command HC on the selection line preceding the report name.

Note:
Using the mode DISPLAY=EDITOR, you can also enter a printer name. The output will be written to report 1, defined with the Natural statement DEFINE PRINTER (1) OUTPUT <printer-id>.

Downloading Report Output

Notes:

  1. The download output will be generated from the display program that Adabas Review creates when a report is saved.
  2. In mode DISPLAY=BASIC, this command requires that you have Entire Connection installed. In mode DISPLAY=EDITOR, data may be downloaded to a Natural work file too.
  3. The DL command is not available from the View Report Results (VW) screen. However, it is available from the View Report Results (VX) screen using the Software AG Editor.

The DL command enables you to download report output to a personal computer. This command may be issued from the Started Reports screen (LS function), the Scheduled Reports screen (LC function) or the History Reports screen (LH function).

Using the Software AG Editor the DL command additionally allows you to enter a column delimiter and route the output to a personal computer or to a Natural Work File, specified in CONFIGDB.

Start of instruction setTo download report results to a PC (work file 7):

  1. Enter the DL command on the selection line preceding the report name.

    Entire Connection prompts you for a file name. A default directory name is displayed; you may specify a different directory name, if desired.

  2. Press ENTER to begin the download procedure.

    You are notified when the download procedure is completed.

    The data downloaded to your personal computer contains only the contents of the fields in the report. The headings and edit masks supplied by the display program do not appear in the downloaded data.

Purging Accumulated Data

The data accumulated by a report that has been started or scheduled may be purged by issuing the PS command from the Started Reports screen (LS function) or the Scheduled Reports screen (LC function). The PS command also deactivates the started or scheduled report so that no further data is accumulated.

Start of instruction setTo purge accumulated data:

  1. Enter the PS command on the selection line preceding the report name from the Started Reports or the Scheduled Reports screen.

    Depending on your profile setting, you may be prompted to confirm the purge request.

  2. Confirm the purge request, if required.

Check of Started Report and Saved Definition

If a report definition will be changed and saved while the report is running, the definition and the display program may differ from the running report. Before executing a VW/VX command, the running report and saved report definition will be checked. Thus unpredictable errors caused by incompatible data may be avoided.

The check is done by comparing the Account Record Length. For a running report this value is returned from the IN command. For the saved definition this value is calculated. If the calculation is not possible, e.g. because a user-defined variable is missing, the check will be ignored and the VW/VX will be executed without check.

Note:
Since the Account Record Length is not unique, running reports and the saved definition may differ, although the Account Record Length is equal.

If the definition and the display program differs from the running report and a REV00525 cones up, refresh the running report and/or regenerate the report and the display program with its original definition.