If your site uses SQL at all, we recommend that you do not use SQL reserved words for tables, columns, and so forth. We recommend avoiding DQL and SQL words even if you normally work in only one mode. The following table shows the words ignored by CA Dataquery in SQL Mode:
In the following table, where more than one word is listed on a line, those words as a group are reserved, not necessarily the individual words that make up the group unless that word is listed separately on its own line. Words followed by an asterisk (*) indicate that word is reserved only in the COBOL language. We reserve the right to add or change reserved keywords as needed.
SQL Reserved Words
|
ADD |
BEFORE |
CALL |
DATA |
|
EACH |
FIRST |
GENERAL |
HANDLER |
|
IF |
JOIN |
KEY |
LANGUAGE |
|
MODIFIES |
NEW |
OF |
PARAMETER |
|
RAISE ERROR |
SELECT |
TABLE |
UNION |
|
VALUES |
WHEN |
XMLATTRIBUTES |
|
|
Copyright © 2014 CA.
All rights reserved.
|
|