Following is a list of reserved keywords in SQL statements. When specifying columns for relational tables, do not use these keywords as column names. The list may grow in future versions of the SQL standard component.
ADD |
DELETE |
KEY |
SCHEMA* |
ALTER |
DESC |
LEADING |
SECOND |
AND |
DISTINCT |
LEFT* |
SELECT |
AS |
DOUBLE* |
LIKE |
SET |
ASC |
DROP |
LOCK* |
SMALLINT |
AVG |
ESCAPE |
LOWER |
SQLCODE |
BETWEEN |
EXISTS* |
MAX |
SQLMSG |
BOTH |
EXTRACT |
MIN |
SUBSTR |
BY |
FETCH |
MINUS* |
SUM |
BYTE |
FIRST |
MINUTE |
SYNONYM* |
BYTES |
FLOAT* |
MONTH |
TABLE |
CASE |
FOR |
NATURAL* |
TEMPORARY |
CHAR |
FORMAT |
NEXT |
TIME |
CHAR_LENGTH |
FROM |
NOT |
TIMESTAMP |
CLOSE |
FULL* |
NULL |
TO |
COALESCE |
GLOBAL |
NUMBER |
TRAILING |
COLUMN |
GRANT* |
NUMERIC |
TRIGGER* |
COMMIT* |
GRAPHIC* |
OF |
TRIM |
COUNT |
GROUP |
ON* |
UNION* |
CREATE |
HAVING |
OPEN |
UNIQUE |
CROSS |
HEX |
OPTION* |
UPDATE |
CURRENT |
HOUR |
OR |
UPPER |
CURSOR |
IN |
ORDER |
USER |
DATABASE |
INDEX |
OUTER* |
USING* |
DATE |
INDICATOR |
POSITION |
VALIDATE* |
DAY |
INNER* |
PRECISION* |
VALUES |
DEBUG |
INSERT |
PRIMARY |
VARCHAR |
DEC |
INT |
PRIOR* |
VIEW* |
DECIMAL |
INTEGER |
REAL* |
WHERE |
DECLARE |
INTO |
RIGHT* |
WHILE |
DEFAULT |
IS |
ROLLBACK* |
WITH |
DEFINITION |
JOIN |
ROW |
WITHIN |
|
|
|
YEAR |
* Currently unsupported under CA OPS/MVS. However, these keywords may be supported in future releases of the product.
Copyright © 2014 CA.
All rights reserved.
|
|