Version 8.2.3
 —  User's Guide  —

Using Reporting Transactions

This section describes reporting transactions and the commands which you can use with them.

Note:
Data maintenance transactions are described in the section Data Maintenance Transactions later in this documentation.

This section covers the following topics:


What are Reporting Transactions?

Reporting transactions are the most important part of Super Natural.

Super Natural's main task is to obtain data from a database file, work file or PC file. Reporting transactions provide you with the framework necessary to tell Super Natural which data you want.

Modes for reporting govern the basic conditions under which the transaction runs, for example report type and report destination.

For further information on modes, see Modes for Reporting in Defining Transaction Modes for Reporting.

When you have finished adding a reporting transaction and run it, Super Natural provides you with the data you have requested in the form of a report.

Note:
You can use the CHECKLIST function and the NEXT function to help you add and modify reporting transactions. For further information, see Using Super Natural.

Top of page

Listing Transactions

Start of instruction setTo obtain a list of transactions

Top of page

Adding Transactions

The following diagram gives you an overview of the paths you can take when adding a reporting transaction. The diagram shows you which steps are mandatory and which are optional.

graphics/graphic93.gif

Start of instruction setTo add a transaction

  1. Enter a new transaction name in the Add field.

    Or:
    Issue the ADD TRANSACTION command.

    The Add Transaction window appears:

     11:56                      ***** Super Natural *****                   93-01-04
                                  - Transaction List -                        SN1110
                                                                                    
     Cmd  Name     Descript +-------------------Add Transaction--------------------+
          *______           !                                                      !
      __  ADD      ________ ! Transaction ID .... _______                          !
      __  AUTO     ________ ! Description ....... (93-01-04 11:56)______________   !
      __  CHECKL   !91-11-2 !                     ______________________________   !
      __  CONT     (92-01-1 !                                                      !
      __  CONTROL  control  ! File name ......... ________________________________ !
      __  CONT2    (91-09-1 !                                                      !
      __  CONT3    1-09-18  ! Modify modes ...... _                                !
      __  CONT4    PERSONNE ! Data maintenance .. N (Y/N)                          !
      __  DATACH   (92-11-1 !                                                      !
      __  DATACH2  (92-11-1 +------------------------------------------------------+
          
        
    
  2. Enter a new transaction name in the Transaction ID field if no name is present.

  3. Modify or delete the transaction description if required.

  4. If you know the name of the file you want to get your data from, enter it in the File Name field.

    The file you choose here is called your primary file.

  5. If you don't know the name of the file you want to use, enter an asterisk (*).

    The File Selection List window appears:

     11:56                      ***** Super Natural *****                   93-01-04
                                  - Transaction List -                        SN1110
                                                                                    
     Cmd  Name     Descript + +----------------File Selection List-----------------+
          *______           ! !     File Name                         Access  Info !
      __  ADD      ________ ! !  _  SAG-TOURS-E-CH-PRICES               R      _   !
      __  AUTO     ________ ! !  _  SAG-TOURS-E-COMPANY                 R      _   !
      __  CHECKL   !91-11-2 ! !  _  SAG-TOURS-E-CONTRACT                D      _   !
      __  CONT     (92-01-1 ! !  _  SAG-TOURS-E-CONTRACT-WRKMKO         D      _   !
      __  CONTROL  control  ! !  _  SAG-TOURS-E-CRUISE                  R      _   !
      __  CONT2    (91-09-1 ! !  _  SAG-TOURS-E-PERSON                  R      _   !
      __  CONT3    1-09-18  ! !  _  SAG-TOURS-E-YACHT                   R      _   !
      __  CONT4    PERSONNE ! !  _  SPOOL-QUEUE                         R      _   !
      __  DATACH   (92-11-1 ! !  _  SUBMIT                              R      _   !
      __  DATACH2  (92-11-1 + !  _  SUE                                 R      _   !
      __  DATACH3  Destinatio !  _  SUP-AAA                             R      _   !
      __  DATACH4  DATA MAINT !  _  SYSSND                              R      _   !
     Add  _______             !  _  SYSTEM1                             R      _   !
                              !                                                    !
     Cmd(s): Modify, Execute, +More: - +-------------------------------------------+
                                                                                    
     
    

    The File Selection List window displays a selection list of the files which you can use and also contains the following columns:

    Column Description

    Access "S" indicates a superfile and "F" indicates a user file. For further information on superfiles, see Defining Files. For further information on user files, see User Files. The codes "R", "U", "A", "D" and "*" indicate file access level. File access levels are only relevant for data maintenance transactions. For further information on data maintenance transactions, see Working with Data Maintenance Transactions.
    Info Mark this column to obtain first comments if available and then an extended file description from the data dictionary Predict. This feature is only available at sites where Predict is installed. No dictionary information is available for user files.

    Inserting fields into a DDM or deleting them affects Super Natural's internal field referencing. This means that you may either not be able to run existing transactions or that running them will result in unpredictable data.

Start of instruction setTo insert a field

  1. Select your primary file.

  2. Press Enter.

    You are returned to the Add Transaction window. The name of the file you have selected is entered in the File Name field.

  3. Mark the Modify Modes field to modify your default transaction modes for the current transaction only.

    If you don't mark this field, you continue to add the transaction using your default modes.
    For further information on transaction modes, see Defining Transaction Modes for Reporting and Defining Transaction Modes for Data Maintenance.

  4. Enter "Y" in the Data Maintenance field if you want to add a data maintenance transaction.

    For further information on data maintenance transactions, see Working with Data Maintenance Transactions.

    If you leave the default setting "N" (No), you continue to add a reporting transaction.

  5. Press Enter.

    The Worksheet appears:

     12:06                      ***** Super Natural *****                04.Jan.1998
     SN3011                           - Worksheet -                           Monday
                                                                                    
     Ref DB    Field Name                         Seq   S/C  Func Def  Info Del     
     AQ        ________________________________   ___   ___   __   __   __   __     
     AR        ________________________________   ___   ___   __   __   __   __     
     AS        ________________________________   ___   ___   __   __   __   __     
     AT        ________________________________   ___   ___   __   __   __   __     
     AU        ________________________________   ___   ___   __   __   __   __     
     AV        ________________________________   ___   ___   __   __   __   __     
     AW        ________________________________   ___   ___   __   __   __   __     
     AX        ________________________________   ___   ___   __   __   __   __     
     AY        ________________________________   ___   ___   __   __   __   __     
     AZ        ________________________________   ___   ___   __   __   __   __     
     BA        ________________________________   ___   ___   __   __   __   __     
     BB        ________________________________   ___   ___   __   __   __   __     
     BC        ________________________________   ___   ___   __   __   __   __     
     BD        ________________________________   ___   ___   __   __   __   __     
                                                                                    
                                                                                    
     Enter "*" in Fieldname column to select fields or enter NEXT                   
     Command ===>                                                                   
     Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
           Help  Next  Exit  Incl        Flip  -     +           Sel   Run   Canc   
    

For information on how to use the Worksheet, see Working with the Worksheet.

As shown in the diagram at the beginning of this section, you can leave the Worksheet to perform one of several major functions in any order you wish. The following table shows the major functions available from the Worksheet and where they are documented:

Function section Where it is Documented

Selection criteria specification (mandatory) Editors
Calculation criteria specification Editors
Logical condition criteria specification Editors
User exit specification User Exits
Layout editing Natural Report Manager
File linking and/or lookup (Including other files in the transaction) Files
Prototype program generation Prototype Programs

Top of page

Keeping Transactions

If you want to, you can keep a transaction which is either not finished or still has errors in it and finish it later.

Start of instruction setTo save a transaction which is incomplete or has errors in it

Note:
You cannot execute the transaction (for example from the Transaction List) if it has errors or is incomplete.

Top of page

Saving Transactions

If you have completed a transaction but do not want to see the results immediately, you can save it.

Start of instruction setTo save a transaction

Top of page

Running Transactions

If you want to see the results of a transaction, you must run it.

Start of instruction setTo run a transaction

Note:
You cannot run a transaction which has errors in it.

If you want to run an existing transaction without modifying it, it is most efficient to issue the EXECUTE command from the Transaction List screen.

Note:
For further information on the SAVE, KEEP, RUN and EXECUTE commands, see Command List.

If the report is too wide, the Report Line Length window appears. For further information, see Reports Which are Too Wide.

Top of page

Reports Which are Too Wide

When using the transaction modes Destination SCREEN, PRINTER, CON-NECT or EDITOR, you may select so many fields for display that they exceed the width (line length) of the screen or printer to which you are sending the report. If your report is too wide, the Report Line Length window appears when you save or run the transaction:

 12:10                      ***** Super Natural *****                04.Jan.1998
 SNZUL-S                       - Selection Editor -                       Monday
                                                                                
                          +-----------------Report Line Length-----------------+
       1  < AA            !                                                    !
       2  <               ! The selected fields required a line size of .. 149 !
       3  <               ! The field headers required a line size of .... 193 !
       4  <               ! The available Online  line size at present ... 79  !
       5  <               !                                                    !
       6  <               !   _  Enlarge Available Line Size                   !
       7  <               !   _  Change to Report Type Vertical List           !
       8  <               !   _  Truncate Headers                              !
       9  <               !   _  Remove Excess Fields                          !
      10  <               !   _  Remove Excess Fields and Truncate Headers     !
      11  <               !   _  Modify Transaction                            !
      12  <               !                                                    !
      13  <               +----------------------------------------------------+
      14  <                                                              >   14 
      15  <                                                              >   15 
   

The Report Line Length window also appears if the headers of the fields you have selected for display exceed the width (line length) of the screen or printer to which you are sending the report.

The Report Line Length window tells you the line length of the fields and headers you have selected for display, the line length available at present and the Report Destination you are using. The Report Line Length window offers the following options:

Option Description

Enlarge available line size Report Destination SCREEN: The line size can be enlarged to 249 and you can look at the data using the shift functions.
Report Destination CON-NECT: You must make sure that the line size of your report does not exceed that of your screen.
Report Destination PRINTER: You must make sure that the line size of your report does not exceed that of your printer.
Report Destination EDITOR: The line size can be enlarged to 249. If the length of the fields or headers you have selected for display exceeds these values, this option is not available.
Change To Report Type Vertical List The report is displayed as for Report Type Vertical List. Each record is displayed on a separate screen with the display fields and their values listed vertically.
Truncate Headers If only the headers are too wide, you can opt to truncate them (only available if your transaction option setting for "Heading Width Override = N").
Remove Excess Fields Fields are removed from the right-hand side of the report until the required line length is achieved.
Remove Excess Fields Fields are removed from the right-hand side of the and Truncate Headers/tab/report and headers are truncated until the required line length is achieved.
Modify transaction You are returned to the Worksheet where you can modify your report. For example, you can modify your transaction options to make the online screen size larger (for further information, see Working with User Files) or you can modify the width of the columns and their headers by changing their output definition (for further information, see The Field Definition Column in Working with the Worksheet).

Top of page

Modifying Transactions

You may want to go back and modify (change) a transaction once you have run it or modify an existing transaction.

Start of instruction setTo modify a transaction

Transactions with Restricted Access

If you are in a common library, some transactions may have restricted access. Transactions with restricted access are marked with an exclamation mark (!) in the first position in the Description column and you can only execute them.

Top of page

Executing Transactions

If you want to run an existing transaction without modifying it, it is most efficient to issue the EXECUTE command from the Transaction List screen. This is because when you issue the EXECUTE command, Super Natural uses the transaction as it was when the transaction was last run or saved. When you run a transaction using the RUN command, Super Natural completely recreates the transaction even if you have not modified it since it was last run or saved.

Start of instruction setTo execute a transaction

Note:
You cannot execute a transaction which you left using the KEEP command.

Top of page

Copying Transactions

You may not copy a transaction into a public library.

You may not copy transactions with destination USERFILE.

Start of instruction setTo copy a transaction

  1. Enter the command abbreviation CO in the command column of the Transaction List screen next to the transaction name.

    Or:
    Issue the COPY TRANSACTION name command.

    The Copy window appears:

     13:55                      ***** Super Natural *****                04.Jan.1998
     SN1110                       - Transaction List -                        Monday
                                                                                    
     Cmd  Name     Description               +----------------Copy-----------------+
          *______                            !                                     !
      __  ADD      _________________________ ! Source object ... AUTO              !
      CO  AUTO     _________________________ !                                     !
      __  CHECKL   !91-11-26 16:21)_________ ! Target object ... AUTO___           !
      __  CONT     (92-01-16 11:30)_________ ! Common library .. _______           !
      __  CONTROL  control breaks___________ !                   (leave blank for  !
      __  CONT2    (91-09-17 16:06)_________ !                    private library) !
      __  CONT3    1-09-18 14:24____________ !                                     !
      __  CONT4    PERSONNEL FILE + IA______ +-------------------------------------+
        
    

    The Source Object field contains the name of the transaction you want to copy.

  2. Enter the name you want the copy to have in the Target field.

    If you do not make an entry in this field, the copy will have the same name as the original transaction.

    You may not have two or more transactions with the same name in the same library. If you copy a transaction into another library where a transaction of the same name already exists, you are asked if you want to overwrite the existing transaction.

  3. If you want to copy the transaction into a common library, enter its name in the Common Library field.

    If you leave this field blank, the transaction is copied into your private library.

    When you copy a transaction to a new name, the Information function does not show the new name until you modify the transaction.

Top of page

Deleting Transactions

Start of instruction setTo delete a transaction

  1. Enter the command abbreviation DE in the command column of the Transaction List screen next to the transaction name.

    Or:
    Issue the DELETE TRANSACTION name command.

    The Confirm Delete window appears:

     13:56                      ***** Super Natural *****                04.Jan.1998
     SN1110                       - Transaction List -                        Monday
                                                                                    
     Cmd  Name     Description                                                      
          *______                                                                   
      __  ADD      ____________________________________________________________     
      de  AUTO     _ +--------------Confirm Delete---------------+ ____________     
      __  CHECKL   ! !                                           ! ____________     
      __  CONT     ( !                                           ! ____________     
      __  CONTROL  c !        Delete transaction AUTO            ! ____________     
      __  CONT2    ( !                                           ! ____________     
      __  CONT3    1 !        Enter Y to confirm: N              ! ____________     
      __  CONT4    P !                                           ! ____________     
      __  DATACH   ( !                                           ! ____________     
      __  DATACH2  ( !                                           ! ____________     
      __  DATACH3  D !                                           ! ____________     
      __  DATACH4  D +-------------------------------------------+ ____________     
     Add  _______                                                                     
    
  2. Enter "Y" to confirm the deletion.

    You can also delete several transactions at the same time. In this case, the Confirm Multiple Delete window appears. You can choose if you want to confirm each deletion, delete without confirmation or cancel the deletion.

Top of page

Information (Info) Function

Start of instruction setTo obtain information about a transaction

Top of page

Commands Available From Within a Transaction

The following commands are available from within a transaction (the default PF key functions and commands specific to the Worksheet are not included):

Note:
For a list of the default PF key functions, see Using Super Natural.

Note:
For a list of commands specific to the Worksheet, see Working with the Worksheet.

Command (Abbreviation) Description
CALCULATION (CAL) Invokes the Calculation Editor.
CHECKLIST (CHECKL) Invokes the Checklist window (not in Natural Report Manager).
COUNT (COU) Counts the number of records found by the present transaction but does not display the resulting data.
GENERATE (GE) Generates a prototype program from the transaction you are working on. You cannot generate a prototype program from a transaction which is not finished.
INCLUDE (INC) Invokes the Include Files window where you can do the following (not in Natural Report Manager):
  - Change the original primary file (as long as no fields have been used or user fields defined)
- Define/change a secondary file
- Define/change the lookup file(s)
KEEP (K) Keeps any transaction even if it contains errors.
  When you keep a transaction, the commentary lines (transaction specification) for a Natural program are generated and saved but the Natural program for the transaction itself is not generated. If you keep a transaction which has already been run or saved, the program generated by the run or save is deleted and only the commentary line are kept.
LAYOUT (LA) Invokes the Layout Editor which displays either the default layout for the current transaction or a layout you have already edited.
LOGICS (LOG) Invokes the Logical Conditions Editor.
MODES (MODES) Invokes the Modify Modes for Reporting or the Modify Modes for Data Maintenance window depending on the type of transaction you are creating or modifying.
  The modifications you make in these windows are only valid for the current transaction.
  Issue from within a transaction (not in Natural Report Manager).
NEXT (NE) Takes you to the next step you have selected in the Checklist window. If you have selected no further function, the Checklist window appears. (not in Natural Report Manager).
OPTIONS (O) Invokes the Transaction Options window.
  The modifications you make in this and the following windows are only valid for the current transaction (not in Natural Report Manager).
RELEASE (REL) All fields not currently in use in a transaction are removed from the source area and are no longer available. For example, if you invoke the Field List window from an editor or the Worksheet, only the fields in use when you issued the RELEASE command are listed. If you are using very large files, you can use this command to avoid problems with temporary memory capacity (buffer overflow) (not in Natural Report Manager).
RUN (RU) Runs a transaction you are modifying or creating. You cannot run a transaction which is not finished or still has errors in it
  When you run a transaction, a Natural program is generated, cataloged and executed.
SELECTION (SEL) Invokes the Selection Editor, PC file editor or Work File editor depending on the selection mode setting.
SAVE (SA) If you have completed a transaction but do not want to see the results immediately, you can save it. You cannot save a transaction which still has errors in it. You can execute a transaction using the EXECUTE command when it has been saved.
  When you save a transaction, a Natural program is generated and cataloged but not run.
TABULAR (TABU) Invokes the Tabular Report Specification screen when you are adding a report of report type TABLE. Issue from within a transaction of report type TABLE (not in Natural Report Manager).
USEREXIT (USERE) Invokes the Exit Specification screen.
WORKSHEET (W) Invokes the Worksheet (not in Natural Report Manager).

Top of page