Working in SQL Mode allows you to use SQL to create queries and dialogs, as well as to complete other interactive SQL tasks, if authorized.
Working in DQL Mode allows you to execute existing DQL queries, and create your own queries using the DQL. It also allows you to create terms (words especially defined for use in queries).
The USER PROFILE panel (DQK10) displays your current mode of operation and, if you are authorized to change modes, allows you to make an entry that changes your mode.
If you want to access DQL queries, write queries or dialogs in DQL, or execute existing DQL queries or dialogs, make sure you are working in DQL Mode. To use SQL, be sure you are working in SQL Mode. You can use the Personal Database Facility in either mode.
Prerequisites
You can only change modes if your CA Dataquery Administrator has authorized you to do so.
Procedure
Change modes through the USER PROFILE panel by following this procedure:
Display your USER PROFILE (PROFILE command).
Type DQL or SQL in the QUERY LANGUAGE field.
Press <PF4> UPDATE and exit the USER PROFILE panel.
Once your User Profile is updated, you are operating in the new mode. See the CA Dataquery Reference Guide for syntax information for DQL and SQL queries.
|
Copyright © 2014 CA.
All rights reserved.
|
|