How to switch from DQL to SQL mode in CA Dataquery ?

Document ID : KB000046113
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

When I logon to Dataquery Online , DQRY , I am in DQL mode but I need to run SQL queries .

How do I go to SQL mode ?

Environment:  

CICS Transaction Server

Answer: 

After signon to DQ , DQRY , enter SET MODE SQL in the command line to switch to SQL mode.

Your DQ profile will be updated so next time when you signon to Dataquery you will be in SQL mode .

If you want to run in DQL mode then you enter SET MODE DQL in the command line .

 

You can also change the mode by selecting

5. ADMINISTRATION - DATAQUERY system management

then 1.PROFILE

where you can code DQL or SQL in

QUERY LANGUAGE => DQL Language for queries - SQL or DQL

and press PF4(UPDATE) .

 

Next time when you logon to Dataquery ,you will be in the query mode that you selected .