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