search cancel

DQ093E - UNSPECIFIED SQL ERROR

book

Article ID: 21320

calendar_today

Updated On:

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: