RC/Query for DB2 for Z/OS : Customized Reports
Article ID: 55782
Updated On:
Products
Issue/Introduction
As a 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.
Environment
Release: R20
Component: RCQ
Resolution
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 RC/Query.
Customized Reports work for all list type reports (T-L, DB-T etc.), but not for frame reports, like Detailed reports.
- Type "profile" on the command line within RC/Query and press ENTER.
- Specify "Y" for SAVED REPORTS and PF3 back to RC/Query.
- Invoke a List report - for example Table List.....T/L
- Once the report is displayed, type "SAVE" in the command line and press ENTER.
- Type "REP" in the command line and press ENTER.
- If this is your first time within customized reports, only one item is listed. So, use Edit to select the required report. Only customized reports belonging to your userid will be listed.
- The selected report layout is now available for editing. You can:
- Change the COLUMN NAMES by overwriting them
- Xclude columns from being displayed
- Freeze columns
- Move a column Before/After another column
- Once finished editing, just PF3 back to the RC/Query report - and the new layout is displayed.
- The alternate method to change the default layout is to use the commands FREEZE, EXCLUDE etc. once the 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.
If the DEFAULT layout is required again, there are two choices:
- Type "CLEAR" and then press 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.
- Another way to get the default report is to go into the 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 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 must be customized in order for 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.CDBASAMP(RCQSQL).
RQRPT 20.0 -------- RC/Q Edit Customized Report --------- yyyy/mm/dd hh:mm
COMMAND ===> SCROLL ===> CSR
User ID ==> authid1
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: ssid ----------authid1 -
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 20.0 -------- RC/Q Edit Customized Report --------- yyyy/mm/dd hh:mm
COMMAND ===> SCROLL ===> CSR
User ID ==> authid1
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: ssid ----------authid1 -
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 *******************************
Additional Information
Feedback
