Comparing DQL and SQL Modes › Selecting a Mode › Comparative Limitations

Comparative Limitations

Note the following list of limitations for DQL Mode and SQL Mode.

DQL Mode limitations include:

• Does not support nested selects.
• Will not relate a table to itself.
• DQL Mode GUIDE permits only:
  • 15 Conditions per table
  • 10 SORT keys
  • 10 Temporary results
  • 10 Columns to be used in the computation of a temporary result
  • 95 Columns in a PRINT or DISPLAY statement
  • 95 Column functions or legends (total of 95 for both)

SQL Mode limitations include:

• Some columns may not be accessible: repeating fields, redefined fields, fields that are not simple or filler. Some data types are treated as character data.
• Uses only CA Datacom/DB security and does not provide for profile-codes or restricted conditions.
• Allows only 15-digit precision.
• Has no Saved Set Facility, although the STORE command permits saving output as a personal table.
• Does not allow queries to be reexecuted from different points in processing, although reports can be reformatted without reselection.
• Allows limited data types.
• Does not permit term creation.
• Permits only limited translation.
• Only one SQL command is allowed per query.