SQL 予約語のリストです。
Synopsis
%AFTERHAVING | %ALPHAUP | %ALTER | %ALTER_USER | %BEGTRANS |
%CHECKPRIV | %CREATE_ROLE | %CREATE_USER | %DBUGFULL | 
%DELDATA | %DESCRIPTION | %DROP_ANY_ROLE | %DROP_USER | 
%EXACT | %EXTERNAL | %FILE | %FOREACH | %FULL | 
%GRANT_ANY_PRIVILEGE | %GRANT_ANY_ROLE | %INORDER | 
%INTERNAL | %INTEXT | %INTRANS | %INTRANSACTION | %MCODE | 
%NOCHECK | %NODELDATA | %NOINDEX | %NOLOCK | %NOTRIGGER |
%NUMROWS | %ODBCOUT | %ROUTINE | %ROWCOUNT | %STARTSWITH | 
%STRING | %THRESHOLD | %UPPER | 
ABSOLUTE | ACTION | ADD | ALL | ALLOCATE | ALTER | AND | 
ANY | ARE | AS | ASC | ASSERTION | AT | AUTHORIZATION | AVG |
BEGIN | BETWEEN | BIT | BIT_LENGTH | BOTH | BY | CASCADE |
CASE | CAST | CATALOG | CHAR | CHARACTER | CHARACTER_LENGTH |
CHAR_LENGTH | CHECK | CLOSE | COALESCE | COBOL | COLLATE | 
COLLATION | COLUMN | COMMIT | CONNECT | CONNECTION | 
CONSTRAINT | CONSTRAINTS | CONTINUE | CONVERT | 
CORRESPONDING | COUNT | CREATE | CROSS | CURRENT | 
CURRENT_DATE | CURRENT_TIME | CURRENT_TIMESTAMP | 
CURRENT_USER | CURSOR | DATE | DAY | DEALLOCATE | DEC | 
DECIMAL | DECLARE | DEFAULT | DEFERRABLE | DEFERRED | 
DELETE | DESC | DESCRIBE | DESCRIPTOR | DIAGNOSTICS | 
DISCONNECT | DISTINCT | DOMAIN | DOUBLE | DROP | ELSE | 
END | ENDEXEC | ESCAPE | EXCEPT | EXCEPTION | EXEC | 
EXECUTE | EXISTS | EXTERNAL | EXTRACT | FALSE | FETCH | 
FILE | FIRST | FLOAT | FOR | FOREIGN | FORTRAN | FOUND | 
FROM | FULL | GET | GLOBAL | GO | GOTO | GRANT | GROUP | 
HAVING | HOUR | IDENTITY | IMMEDIATE | IN | INDICATOR | 
INITIALLY | INNER | INPUT | INSENSITIVE | INSERT | INT | 
INTEGER | INTERSECT | INTERVAL | INTO | IS | ISOLATION | 
JOIN | KEY | LANGUAGE | LAST | LEADING | LEFT | LEVEL | 
LIKE | LOCAL | LOWER | MATCH | MAX | MIN | MINUTE | 
MODULE | MONTH | NAMES | NATIONAL | NATURAL | NCHAR | 
NEXT | NO | NOT | NULL | NULLIF | NUMERIC | OCTET_LENGTH | 
OF | ON | ONLY | OPEN | OPTION | OR | ORDER | OUTER | 
OUTPUT | OVERLAPS | PAD | PARTIAL | PASCAL | PLI | 
POSITION | PRECISION | PREPARE | PRESERVE | PRIMARY | 
PRIOR | PRIVILEGES | PROCEDURE | PUBLIC | READ | REAL | 
REFERENCES | RELATIVE | RESTRICT | REVOKE | RIGHT | ROLE | 
ROLLBACK | ROWS | SCHEMA | SCROLL | SECOND | SECTION | 
SELECT | SESSION_USER | SET | SIZE | SMALLINT | SOME | 
SPACE | SQL | SQLCODE | SQLERROR | SQLSTATE | SUBSTRING | 
SUM | SYSTEM_USER | TABLE | TEMPORARY | THEN | TIME | 
TIMESTAMP | TIMEZONE_HOUR | TIMEZONE_MINUTE | TO | 
TRAILING | TRANSACTION | TRANSLATE | TRANSLATION | TRIM | 
TRUE | UNION | UNIQUE | UNKNOWN | UPDATE | UPPER | USAGE | 
USER | USING | VALUE | VALUES | VARCHAR | VARYING | VIEW | 
WHEN | WHENEVER | WHERE | WITH | WORK | WRITE | YEAR |
ZONE
概要
SQL 内では、特定の文字が予約されています。SQL 予約語は、以下の場合を除いて、SQL 識別子 (テーブル名、列名、変数名や、その他のエンティティ名など) としては使用できません。
以下のリストは、このように予約された単語のみを含みます。すべての SQL キーワードを含むわけではありません。
単語が SQL 予約語であるかどうかを調べるには、以下の例に示すように、$SYSTEM.SQL クラス・メソッドを呼び出します。予約語は文字列に引用符を付けて指定します。予約語は大文字と小文字を区別しません。$SYSTEM.SQL.IsReservedWord は、ブーリアン値を返します。
   WRITE !,"Reserved?: ",$SYSTEM.SQL.IsReservedWord("VARCHAR")
   WRITE !,"Reserved?: ",$SYSTEM.SQL.IsReservedWord("varchar")
   WRITE !,"Reserved?: ",$SYSTEM.SQL.IsReservedWord("VarChar")
   WRITE !,"Reserved?: ",$SYSTEM.SQL.IsReservedWord("FRED")
このメソッドは、ODBC または JDBC からストアド・プロシージャ %SYSTEM.SQL_IsReservedWord("nnnn") として呼び出すこともできます。