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
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.
Release : 14.0, 15.0, 15.1
Component : CA Dataquery for CA Datacom
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.
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.