Reserved Words
Each of the symbols or words listed below has a special meaning when processed by the SRDE, unless it is delimited by double-quotes. Using one of these words as a table or object name without double quotes will cause an error.
See also the next section, Words to Avoid .
Symbols
A
ABORT |
ABSOLUTE |
ACCELERATED |
ACTION |
ADD |
AFTER |
ALL |
ALTER |
AND |
ANY |
AS |
ASC |
ATOMIC |
AUTHORIZATION |
AVG |
B
BEFORE |
BEGIN/BEGINS |
BETWEEN |
BINARYNULL |
BIND |
BLANK |
BY |
|
|
C
CALL |
CASCADE |
CASE |
CHAIN |
CHARACTER |
CHECK |
CLOSE |
COBOL |
COLLATE |
COLUMN |
COMMIT |
COMMITTED |
CONDITION |
CONSTRAINT |
CONTINUE |
CONVERT |
COUNT |
CREATE |
CREATETAB |
CROSS |
CS |
CURDATE |
CURRENT |
CURSOR |
CURTIME |
|
|
D
D |
DATABASE |
DCOMPRESS |
DECIMALSEPARATORCOMMA |
DECLARE |
DEFAULT |
DELETE |
DESC |
DIAGNOSTICS |
DICTIONARY |
DISTINCT |
DO |
DROP |
|
|
E
EACH |
ELSE |
ELSEIF |
END |
ESCAPE |
EX |
EXCLUSIVE |
EXEC |
EXECUTE |
EXISTS |
EXTERNAL |
|
F
FETCH |
FIRST |
FN |
FOR |
FOREIGN |
FROM |
FULL |
|
|
G
H
I
IDENTITY |
IF |
IN |
INCLUDE |
INDEX |
INNER |
INOUT |
INSERT |
INTERNAL |
INTO |
IS |
ISOLATION |
J
JOIN
K
KEY
L
LANGUAGE |
LAST |
LEAVE |
LEFT |
LEGACYOWNERNAME |
LENGTH |
LEVEL |
LIKE |
LOGICAL |
LOGIN |
LOOP |
LOWER |
M
MAX |
MILLISECOND |
MIN |
MINUTE |
MODIFIABLE |
MODIFY |
MODULE |
MONEY |
MONTH |
N
NEW |
NEXT |
NO |
NORMAL |
NOT |
NOTFOUND |
NOW |
NULL |
|
O
OF |
OFF |
OLD |
ON |
ONLY |
OPEN |
OPENMODE |
OPTION |
OR |
ORDER |
OUT |
OUTER |
OWNER |
OWNERACCESS |
|
P
PAGESIZE |
PREALLOCATE |
PREPARE |
PRIMARY |
PRINT |
PRIOR |
PRIVILEGES |
PROCEDURE |
PUBLIC |
R
RANGE |
READ |
READONLY |
REFERENCES |
REFERENCING |
RELATIVE |
RELEASE |
REPEAT |
REPEATABLE |
REPLACE |
REPLICATION |
RESIGNAL |
RESTRICT |
RETURN |
RETURNS |
REVOKE |
RIGHT |
ROLLBACK |
ROW |
ROWCOUNT |
|
S
SAVEPOINT |
SCHEMA |
SCROLL |
SECURITY |
SEG |
SELECT |
SERIALIZABLE |
SET |
SIGNAL |
SIZE |
SOME |
SQLERROR |
SQLEXCEPTIONS |
SQLWARNINGS |
SQLSTATE |
SSP_EXPR |
SSP_PRED |
START |
STATEMENT |
STRINGNULL |
SUM |
SVBEGIN |
SVEND |
|
T
T |
TABLE |
THEN |
THRESHOLD |
TO |
TOP |
TRANSACTION |
TRIGGER |
TRIGGERSTAMPMISC |
TRUENULLCREATE |
TS |
TYPE |
U
UNCOMMITTED |
UNDO |
UNION |
UNIQUE |
UNTIL |
UPDATABLE |
UPDATE |
UPPER |
USER |
USING |
|
|
V
VALUE, VALUES |
VERIFY |
VIEW |
W
WHEN |
WHERE |
WHILE |
WITH |
WORK |
WRITE |
Y
YEAR
Z
ZSTRING