Cross-Report: SELECT BY INDEX

User Modes: Initiating Output Retrieval › Cross-Report Indexing › Cross-Report: SELECT BY INDEX

Cross-Report: SELECT BY INDEX

You might know the name of a page index defined to a SYSOUT, but not remember the SYSOUT ID. In the Primary Selection panel, you might specify:

The PAGE INDEX name
Blanks for SYSOUT ID
SELECT BY I (index)

All page indexes having the name you specified are displayed, regardless of their respective SYSOUT IDs. When you select a specific index value (the actual text from the indexed location), you see the SYSOUT IDs of the reports for which that text was found.

The following examples illustrate the SELECT BY INDEX option.

Example 1

Assume you want to SELECT By Index.

Enter the following information in the Primary Selection panel:

CA View ALL --- Primary Selection for VIEW.SYSTEM1 -------------------------
Command ===> 
                                                    
Sysout ID     ===>               
Select by     ===> I                     (R, I, IL, or IR)          
Index Name    ===>            Value ===>                                    
              ===>                  ===>                                    
              ===>                  ===>                                    
              ===>                  ===>                                    
                                                                            
Selection Criteria:                                                            
   Generation ===> *                     (*, ALL, specific (n), relative (-n), 
                                          range (n:m or -n:m))                 
                                                                                
    Date      ===>                       (specific (mm/dd/yyyy), relative (-n),
                                          range(mm/dd/yyyy:mm/dd/yyyy or -n:m))
                                                                                
Selection Options:    Only specify to restrict selection                       
   Exceptions ===>    X exceptions only, NX non exceptions only, AX/(blank) any
   Permanent  ===>    P permanent only,  NP non permanent only,  AP/(blank) any
                                                                                
              Enter END command to terminate this CA View session.

Press Enter to display the index selection list generated by the criteria.

CA View ALL ------------- Index Name Selection List ------- Row 00001 of 00010 Command ===> Scroll ===> PAGE Sel Index ----------------- S U B I N D E X N A M E S ------------------ ACCOUNT DATE DIVISION NAME DIVISION NAME,STATE,DATE NAME DIVISION NAME DIVISION,STATE,DATE NUMBER PART STATE SUBSTATE TITLE ****************************** Bottom of Data ********************************

Because you did not specify any information in the SYSOUT ID field of the Primary Selection panel, you have a list of all page index names defined to this CA View database.

Note: To appear in this list, page index names must also be specified as participating in cross-report indexing and have their page indexes residing on the CA View disk database.

Example 2

Assume that you are not aware of all the reports that are run on the system, but you want to see all reports that have BILL JONES as a value for the page index field NAME.

Select page index NAME to see what values have been found in the NAME page index for all reports.

CA View ALL ------------------ Index Name Selection List --------------------- Command ===> Scroll ===> PAGE Sel Index ---------------- S U B I N D E X N A M E S -------------------- ACCOUNT DATE DIVISION NAME DIVISION NAME,STATE,DATE S NAME DIVISION NAME DIVISION,STATE,DATE NUMBER PART STATE SUBSTATE TITLE ******************************* Bottom of Data ********************************

Press Enter to display a panel listing all values found for the page index NAME.

CA View ALL ------------------ Index Name Selection List --------------------- Command ===> Scroll ===> PAGE Sel Name Division BILL JONES 1 BILL WILSON 2 CHUCK JONES 3 CHUCK WOOLERY 4 DAVE CLARK 5 ******************************* Bottom of Data ********************************

These values are the actual text CA View found in the SYSOUTs in the location specified by the page index NAME.

CA View ALL ------------------ Index Name Selection List --------------------- COMMAND ===> Scroll ===> PAGE Sel Name Division S BILL JONES 1 BILL WILSON 2 CHUCK JONES 3 CHUCK WOOLERY 4 DAVE CLARK 5 ******************************* Bottom of Data ********************************

Enter S next to BILL JONES to see all reports that have the value BILL JONES for the page index NAME.

Press Enter to display this list of SYSOUTs.

CA View ALL ----------------- Sysout Selection List ---------------------------- Command ===> SCROLL ===> HALF Sel Sysout ID Arch Date Time Loc Lines Pages ==> * * * * * * BILLING 11/10/2013 16:38 PTAP 745 36 HISTORY 11/10/2013 16:38 PTAP 506 14 INVNTRY 11/10/2013 16:38 PDK2 103 8

On this CA View database, three reports—BILLING, HISTORY, and INVNTRY—have a page index called NAME, and have the text BILL JONES as a value for that index. You can now check all reports on the system for this customer.

Example 3

If you specify any criteria in the SYSOUT ID field of the Primary Selection panel, you see only the reports that match the specified criteria.

For example, specify BILLING as a SYSOUT ID in the Primary Selection panel:

CA View ALL --- Primary Selection for VIEW.SYSTEM1 -------------------------- 
Command ===> 
                 
Sysout ID     ===> billing 
Select by     ===> i                     (R, I, IL, or IR) 
Index Name    ===> name       Value ===>  bill jones
              ===>                  ===> 
              ===>                  ===>                                    
              ===>                  ===>                                    
                                                                               
Selection Criteria:                                                            
    Generation ===>                      (*, ALL, specific (n), relative (-n), 
                                          range (n:m or -n:m))                 
                                                                               
    Date      ===>                       (specific (mm/dd/yyyy), relative (-n),
                                          range(mm/dd/yyyy:mm/dd/yyyy or -n:m))
                                                                               
Selection Options:    Only specify to restrict selection                       
    Exceptions===>    X exceptions only, NX non exceptions only, AX/(blank) any
    Permanent ===>    P permanent only,  NP non permanent only,  AP/(blank) any
                                                                               
              Enter END command to terminate this CA View session.

CA View Browse - BILLING ------ Rec 0000036 Pg 0000010.001 Lock 00 Col 001 080 Command ===> Scroll ===> PAGE ********************************* Top of Data ********************************** Name Division XXXX XXXXXXXX XXXX XXXXXXXX XXXX XXXXXXXX XXXX XXXXXXXX XXXX XXXXXXXX XXXX XXXXXXXX XXXX XXXXXXXX XXXX XXXXXXXX XXXX XXXXXXXX ******************************** Bottom of Data ********************************

There may be many copies of the BILLING report that are displayed.

If many of their page indexes are on disk, specify a date or generation criteria for best performance.