DQ093E - UNSPECIFIED SQL ERROR

Products

• Datacom
• DATACOM - AD
• Ideal
• 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

Issue:

Trying to use CA Datacom Dataquery SQL option or executing a SQL Dataquery I am getting message DQ093E - UNSPECIFIED SQL ERROR. Why?

Resolution:

From the CA Dataquery Message Reference Guide:

DQ093E - Unspecified SQL Error

- Explanation: Advantage CA-Dataquery has encountered an unexpected error when processing an SQL statement. The return codes and diagnostic information    supplied by the database are displayed after you press PF1.

- User Response: Contact your Advantage CA-Dataquery Administrator and describe the error message, including the text, message number and diagnostic information  displayed above, and what you were doing when the error occurred.

 

To help diagnose the situation:

If PF1 shows that you have received a Datacom return code of 36(192) then check if the SQL URT (generally DBURT020) is opened on in your CICS region.

Issue the CA Datacom CICS Services (DBC) inquiry command DBOC INQ= :

  DBOC INQ=20                                            DELIM &

  URT 0020(SQL UNOPENED      )                   PRTY=07 TXNUD
  DC00380I  TRANSACTION COMPLETED.

 

Return code 36(192) means that the SQL URT is closed.

If DBOC shows UNOPENED, then you can manually open URT 20 via the DBC command DBOC OPEN= :

DBOC OPEN=20 

DC00171I URT 0020 now opened DC00380I Transaction Completed.

 

Additional information:

See the Advantage CA-Dataquery Administrator

See the Advantage CA-Datacom/DB Message Guide for an explanation of the return codes.

 

 

 

 

Environment

Release: DATABB00200-14-Datacom/AD
Component: