Execute RC/Query line command "REPORT SAVE" results in Error Message RQ118I.

book

Article ID: 52503

calendar_today

Updated On:

Products

CA RC Compare for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Description

Generate under RC/Query a TABLE(T) LIST(L) or VIEW(V) LIST(L) Report like:

 DB2 Object ===> T                     Option  ===> L            Table Name ===> sysdummy1             Creator ===> SYSIBM       Qualifier ===> *                      Grantor ===> * 
went into RC/Query Table List Report Screen (PanelID RQTL). If you would like to save this Report and execute line command
" REPORT SAVE "
could result in:
RQ118I: No customized report formats found for xxxxx(USERID). 

Solution

The "REPORT SAVE" command combination will only work, if any Report for this Userid was created in the past. If no User Report exist, this combination of "REPORT" and "SAVE" will not work. The valid commands for customized reports are:

  REPORTS   - displays all report formats for a userid on a particular ssid SAVE      - save a customized report format CLEAR     - temporarily clear the customized report format. This does not delete any customized formats. 

So for the first time, the SAVE command and not SAVE REPORT command allows you to save the current report format as a personal customized report format. The customized report format will be used to display subsequent reports from RC/Query when your profile value is set to display using customized report formats (SAVED REPORTS= Y).

Environment

Release:
Component: RCQ