Cross-Report: SELECT BY REPORT

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

Cross-Report: SELECT BY REPORT

You may know the SYSOUT ID but not know the page index names that are defined to the SYSOUT. In the Primary Selection panel, you might specify:

The SYSOUT ID
Blanks for PAGE INDEX NAME
SELECT BY R (report)

The result is:

A list of all logical views for the SYSOUT ID you specified is displayed.
The page index names are listed next to the logical view names.
You can use the listed information to select the view that has the page index you want.

The following examples illustrate the SELECT BY REPORT option.

Example 1

Enter R (SELECT BY REPORT) in the Primary Selection panel.

CA View ALL --- Primary Selection for VIEW.SYSTEM1 ---------------------------
Command ===>                                                                  
                                                                              
Sysout ID     ===>               
Select by     ===> R                    (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 a SYSOUT selection list.

CA View ALL -------------- Sysout Selection List ------------------------------ Command ===> Scroll ===> HALF Sel Sysout ID Arch Date Time Loc Lines Pages ==> * * * * * * BALANCES 11/10/2013 16:38 PTAP 745 36 BILLING 11/10/2013 16:38 PTAP 506 14 CREDITS 11/10/2013 16:38 PDK2 103 8 DEBITS 11/10/2013 16:38 PDK2 25 2 HISTORY 11/10/2013 09:50 PTAP 86 7 INVNTRY 11/10/2013 09:50 PTAP 86 7 SUMMARY 11/10/2013 09:50 PTAP 86 7

You now have a list of all reports defined to this CA View database regardless of index name information because you specified SELECT BY REPORT.

Example 2

Suppose you want to see all page indexes that are defined to the BILLING report. You can see a list of all logical views defined to the report, and this list includes all defined page index names.

Enter S next to BILLING, the desired SYSOUT ID.

CA View ALL -------------- Sysout Selection List ------------------------------ Command ===> Scroll ===> HALF Sel Sysout ID Arch Date Time Loc Lines Pages BALANCES 11/10/2013 16:38 PTAP 745 36 S BILLING 11/10/2013 16:38 PTAP 506 14 CREDITS 11/10/2013 16:38 PDK2 103 8 DEBITS 11/10/2013 16:38 PDK2 25 2 HISTORY 11/10/2013 09:50 PTAP 86 7 INVNTRY 11/10/2013 09:50 PTAP 86 7 SUMMARY 11/10/2013 09:50 PTAP 86 7

Press Enter to display a list of all logical views that exist for this report.

This result occurs because the targeted report has logical views and page indexes defined to it.

CA View EXPO -------------------- View Selection ------------------------- Command ===> Scroll ===> HALF Index Value ===> Sel Num Acc View ID Description __ 000 PUB REPORT1 NATIVE BROWSE __ 001 PUB VIEW INDEXED BY DIVISION AND NAME __ 002 PUB VIEW INDEXED BY TITLE __ 003 PUB VIEW INDEXED BY STATE __ 004 PUB VIEW INDEXED BY DATE __ 005 PUB VIEW INDEXED BY NAME __ 006 PUB __ 007 PUB __ 008 PRV USER PRIVATE LOGICAL VIEW

With each view, the page indexes defined to that view are listed. You see that logical view 005 has the index called NAME.

Enter S next to 005 to obtain a list of the values that were found for that page index.

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

On the CA View database, these values for the page index NAME were found in the BILLING report. You can now select any NAME, and view the BILLING report pages indexed for that name.