Reserved and Ignored Words

Using words that have special meaning to CA Dataquery or words that are ignored by CA Dataquery in places where CA 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:

CA Dataquery system commands
CA Dataquery Editor commands
DQL and SQL keywords
DQL and SQL ignored words
Translations of reserved words

Translations:

Translations of CA Dataquery with the CA 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 CA 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