One resolution for CA Dataquery error DQ025E

book

Article ID: 141057

calendar_today

Updated On:

Products

CA Datacom CA Datacom/DB CA Datacom/AD

Issue/Introduction

When running CA Dataquery DQL queries online, an error can be produced:

DQ025E - YOU NAMED A TABLE IN YOUR QUERY THAT WASN'T IN YOUR FIND STATEMENT 

Cause

When CICS-related URTs are created, entries for each table should have SYNONYM=YES to force applications to also include the DBID on each request. With SYNONYM=NO, a table that exists in multiple databases could lead to the wrong database being used.

Environment

Release : 14.0, 15.0, 15.1

Component : CA Dataquery for CA Datacom

Resolution

Review all online URTs that could contain a like-named table in other DBIDs, and ensure that all entries contain the parameter SYNONYM=YES. This will cause the DBID to be included with the request so that the correct DBID is used on each database request.

Additional Information

For more information on defining the User Requirements Table (URT), please refer to the CA Datacom/DB Database and System Administration documentation, in the section titled "Defining the User Environment."

As always, please contact CA Technologies support for CA Datacom if you have further questions.