Comparing DQL and SQL Modes

When you operate in SQL Mode, most CA Dataquery features function the same way they do when you operate in DQL Mode. Each mode offers some features that are not available in the other mode and minor differences in panels and functionality exist.

Each mode allows you to use its own language to create queries and also allows you to use queries stored in its libraries. If you are familiar with using CA Dataquery in either mode, you only need to know about these differences:

Feature	DQL Mode	SQL Mode
Tables	Queries can access all CA Datacom/DB tables.	Queries can only access tables that are relationally correct.
Saving Found Sets	KEEP command allows you to create a saved set during output display. See Saving and Using DQL Mode Sets for details.	STORE command allows you to create a personal table during output display. See the CA Dataquery Reference Guide for details.
Terms	Available.	Not available.
Syntax	Uses DQL syntax (including keywords such as FIND, SET, SORT, PRINT, DISPLAY). Keys can be used as PRINT columns and to join tables.	Uses SQL syntax (including keywords such as SELECT, WHERE, GROUP BY, ORDER BY). CA Datacom/DB keys are not used in SQL queries.
Precision	A number like 13.2 means there are 13 integer positions and 2 decimal positions.	A number like (13,2) means there are 11 integer positions and 2 decimal positions.
Security	Uses CA Dataquery table and column security in addition to CA Datacom/DB security.	Uses only CA Datacom/DB table and column security and Grant and Revoke privileges.
Reporting	Report specifications are included in the query. Some formatting changes are possible during execution, such as inclusion or omission of totals.	Reports appear in default format unless you specify otherwise at execution. To sort, the query must contain an ORDER BY clause so that rows are retrieved in sorted order.
Plan Options	Preset by the CA Dataquery System Option Table for all users. Some storage limits can be altered by the CA Dataquery Administrator.	Defaults can be altered on a query-by-query basis, with CA Dataquery Administrator or DBA approval. Options are coded as CA Dataquery comments on line one of the query. Options of interest to users may be the time and date output formats.