

Comparing DQL and SQL Modes › Selecting a Mode › Advantages
Advantages
Note the following list of advantages for DQL Mode and SQL Mode.
DQL Mode:
- Permits outer joins.
- Allows 18-digit precision.
- Handles more data types than SQL.
- Reads all accessible data in all tables.
- Can be translated into other languages.
- Has field level and content security without views.
- Queries can be executed in stages and re-executed starting at any stage.
- Offers a catalogued reusable syntax (terms) for use in queries.
- Supports the relational equijoin.
- Saves pointers to retrieved data that can be reused (saved sets).
SQL Mode:
- Allows a table to be related to itself.
- Allows nested SUBSELECTs.
- Supports full relational joins.
- Supports views.
- Supports the dynamic creation and dropping of tables.
- Supports the creation of summarization rows.
- Supports a test for existence, for instance, has complete null support.
- Supports data selection based on column functions.
Copyright © 2014 CA.
All rights reserved.
 
|
|