DQ801E - using OPTION DIAGNOSTICS=CBS

book

Article ID: 128966

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET 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.