CA Dataquery Reserved and Ignored Words

Using words that have special meaning to dqd or words that are ignored by dqd in places where dqd does not expect them causes problems during execution of any query or dialog containing them.
datacom151
Using words that have special meaning to
Dataquery
or words that are ignored by
Dataquery
in places where
Dataquery
does not expect them causes problems during execution of any query or dialog containing them.
Do Not Use:
When assigning names to such things as tables, sets, queries, columns, keys, temporary results, terms, and so on, do not use words from these categories:
  • Dataquery
    system commands
  • Dataquery
    Editor commands
  • DQL and SQL keywords
  • DQL and SQL ignored words
  • Translations of reserved words
Translations:
Translations of
Dataquery
with the
Dataquery
Language Facility are also affected by reserved words. Any translation of a reserved word is also a reserved word.
DQL Ignored Words:
The following table shows the words ignored by
Dataquery
:
ALL
AND
ASCENDING
BREAK
BREAKS
BY
COLUMN
COLUMNS
FIELD
FIELDS
FILE
FILES
FROM
IN
INTO
KEY
KEYS
OF
ON
RECORD
RECORDS
ROW
ROWS
TABLE
TABLES
THAN
THE
THEM
THEN
TO
UP
VIA