SQL Mode Limitations

Review the limitations in this section when using CA Dataquery in SQL Mode.

The sum of the lengths of all the columns in an SQL query cannot exceed the DQESIZE parameter in the System Option Table.
An SQL query report cannot be formatted until the SQL query is validated.
SQL language verbs cannot be translated.
The CANCEL FIND function cannot be used to cancel an SQL query.
A joined view cannot be updated.
The number of tables/views in a single query cannot exceed 10.
Terms cannot be used.
The length of an authorization ID cannot exceed 18 characters.
An internal table may be exceeded if excessive amounts of the following (or combination of the following) have been specified in a query:
- Number of columns selected in a query
- Number of alternate headings in a report format
- Number of control breaks in a report format
- Number of column functions in a report format
- Number of long literals specified for column values in an insert query
Only one SQL command is allowed per query.