DQ801E - using OPTION DIAGNOSTICS=CBS

book

Article ID: 128966

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction



Dataquery OPTION DIAGNOSTICS=CBS  gives error:
DQ801E - "THE FIRST COMMAND IN YOUR QUERY IS NOT RECOGNIZABLE TO DATAQUERY"  

Environment

CA Dataquery 14.0 and above

Resolution

The DQBATCH input card will generate a CBS trace in the PXX or MUF SYSOUT if the request is successful.

If for any reason the request cannot be processed the message DQ801E will be produced.

In our case the request without the DIAGNOSTICS card was getting:
DQ180I - QUERY EXECUTION WAS STOPPED BECAUSE NO ROWS WERE FOUND 

Additional Information

OPTION DIAGNOSTICS=
(Optional - Valid in DQL Mode only.) Produces Compound Boolean Selection diagnostics report or the request table. The format of the OPTION DIAGNOSTICS statement is as follows:
►►─ OPTION ─ DIAGNOSTICS= ─┬─ CBS ───┬────────────────────────────────────────►◄ ├─ OFF ◄ ─┤ └─ RQT ───┘
This option specifies printing of a Compound Boolean Selection diagnostics report, the request table, or no diagnostics.
Valid Entries:
CBS, OFF, or RQT
Default Value:
OFF
Note: If RQT is used, this statement should follow either the FIND or EXECUTE statement. Otherwise, it should precede the FIND or EXECUTE statement.