Problems with Query

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

Running a batch SQL query through CA Dataquery batch produces errors sporadically, even though the JCL never changes.

DQ805E - THE TABLE NAME YOU USED IS UNKNOWN TO DATAQUERY                    

  SELECT C.column_name                                                     

         **************                                                     

EXECUTE *                                                                    

 DQ801E - THE FIRST COMMAND IN YOUR QUERY IS NOT RECOGNIZABLE TO DATAQUERY  

EXPORT 'DQOUT' DETAIL                                                        

 DQ399E - TO EXTRACT DATA, YOUR QUERY MUST CONTAIN A PRINT/DISPLAY STATEMENT

Environment

Release : 14.0

Component : CA Dataquery for CA Datacom

Resolution

Following the DQ signon statement, please add this statement:

OPTION QUERYLANG=SQL

If this statement is not present, the CA Dataquery processing will assume the previous setting at the time of the user signoff. If a previous job used the SQL QueryLang, then this job would use SQL. However, if the previous job used DQL, this job would also use DQL here, and result in giving this misleading message.

The OPTION QUERYLANG statement should always be used to indicate the intent.

Additional Information

For more information about running CA Dataquery in Batch mode and the process of signon, please refer to the CA Datacom Core 15.1 documentation for the section Batch Sign/On Management.

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