Trying to use CA Datacom Dataquery SQL option or executing a SQL Dataquery I am getting message DQ093E - UNSPECIFIED SQL ERROR. Why?
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= :
DC00171I URT 0020 now opened DC00380I Transaction Completed.
See the Advantage CA-Dataquery Administrator
See the Advantage CA-Datacom/DB Message Guide for an explanation of the return codes.