Customized Reports within Unicenter RC/Query

Document ID : KB000055782
Last Modified Date : 14/02/2018
Show Technical Document Details

As a Unicenter RC/Query for DB2 for z/OS user you probably have to scroll to the right from time to time to see some of the information which is important to you. This could be the column names in an index-column report or the record length in a table-list report. To see the most important information without having to use PF11 to scroll to the right, let's take a closer look at a feature called Customized Reports within Unicenter RC/Query.

Customized Reports works for all list type reports (T-L, DB-T etc.), but not for frame reports, like Detailed reports.

  1. Type "profile" on the command line within Unicenter RC/Query and hit ENTER.
  2. Specify "Y" for SAVED REPORTS and PF3 back to Unicenter RC/Query.
  3. Invoke a List report - for example Table List
  4. Once the report is displayed, type "SAVE" in the command line and hit ENTER.
  5. Type "REP" in the command line and hit ENTER.
  6. If this is your first time within customized reports, you only have one item listed. So, use Edit to select the required report. You will only see the list of customized reports belonging to you.
  7. The selected report layout is now available for editing. You can:
    1. Change the COLUMN NAMES by overwriting
    2. Xclude columns from being displayed
    3. Freeze columns
    4. Move a column Before/After another column
  8. Once you are finished editing, just PF3 back to the Unicenter RC/Query report - and the new layout is displayed.
  9. The alternate method to change the default layout is to use the commands FREEZE, EXCLUDE etc. once the Unicenter RC/Query report is displayed. Using the Customized Report feature, the desired layout will be used every time this report type is requested. It's not necessary to use the commands EXCLUDE, FREEZE etc. every time.
  10. If you want to use the DEFAULT layout again, you have two choices:
    1. Type "CLEAR" and then hit ENTER. The next report for this type will use the default report. Switching back to the customized report can be done by typing "REP" again and then selecting the customized report.
    2. Another way to get the default report is to go into the Unicenter RC/Query profile (PROF) and specify "N" for SAVED REPORTS. The customized report (created earlier) will not be deleted - it can be activated at any time by specifying SAVED REPORTS "Y" in the Unicenter RC/Query profile.
    Below is an example illustrating the Table-List report layout before and after a customization. The example illustrates that "CREATEDBY" column has been excluded from the display, "N ROWS" has been renamed to "NUMBER OF ROWS" and has been moved up to be the third column. Column "REC LEN" has been changed to "RECLENGTH", column "COL CNT" has been renamed to "NUM-COLS" and moved up as the fourth column in the display.

    If any error messages are displayed during the SAVE and REP commands, the most likely reason is missing product post install customization. Two tables need to be customized in order for Unicenter RC/Query customized reports to work properly:
    PTI.PTRCQ_DESC_0200 and PTI.PTSQL_TEXT_0101
    These DB2 tables are populated during the post install process via SQL in highlvl.SRCLIB(RCQSQL).
RQRPT  R11.00 --------  RC/Q Edit Customized Report --------- 2004/04/08 10:26
COMMAND ===>                                                  SCROLL ===> CSR 
                                                                              
        User ID       ==> RASST02                                             
        Report Type   ==> T           Option ==> L                            
                                                                              
       Use F to toggle Frozen flag, X to toggle Exclude flag.                 
       Place an H in command line for Field Descriptions help.                
       Change column order with (M)ove, (A)fter, & (B)efore.                  
Loc: LOCAL ---------- SSID: M81A ----------RASST02 -                           
CMD COLUMN NAME                     EXCLUDED FROZEN MX LEN                     
___ TABLE NAME__________              NO      YES   20                         
___ CREATOR___                        NO      NO    10                         
___ CREATEDBY__                       NO      NO    11                         
___ DATABASE__                        NO      NO    10                         
___ TBLSPACE__                        NO      NO    10                         
___ N. ROWS__________                 NO      NO    17                         
___ COLCNT___                         NO      NO    9                          
___ REC LEN__                         NO      NO    9                          
___ LABEL_________________________    NO      NO    30                         
___ STATSTIME___________________      NO      NO    28                         
___ TYPE_                             NO      NO    5                          
******************************** 
BOTTOM OF DATA 
*******************************


RQRPT  R11.00 --------  RC/Q Edit Customized Report --------- 2004/04/08 10:28
COMMAND ===>                                                  SCROLL ===> CSR 
                                                                              
        User ID       ==> RASST02                                             
        Report Type   ==> T           Option ==> L                            
                                                                              
       Use F to toggle Frozen flag, X to toggle Exclude flag.                 
       Place an H in command line for Field Descriptions help.                
       Change column order with (M)ove, (A)fter, & (B)efore.                  
Loc: LOCAL ---------- SSID: M81A ----------RASST02 -                           
CMD COLUMN NAME                     EXCLUDED FROZEN MX LEN                     
___ TABLE NAME__________              NO      YES   20                         
___ CREATOR___                        NO      NO    10                         
___ NUMBER OF ROWS___                 NO      NO    17                         
___ NUM-COLS_                         NO      NO    9                          
___ CREATEDBY__                       YES     NO    11                         
___ DATABASE__                        NO      NO    10                         
___ SPACE_____                        NO      NO    10                         
___ RECLENGTH                         NO      NO    9                          
___ LABEL_________________________    NO      NO    30                         
___ STATSTIME___________________      NO      NO    28                         
___ TYPE_                             NO      NO    5                          
******************************** 
BOTTOM OF DATA 
*******************************