SQL reserved keywords for Informix Dynamic Server, V11

If an abstract field or bean name for a container managed persistence (CMP) entity beans uses a SQL reserved keyword, the top-down mapping adds a numeric suffix to the column name when generating the data definition language file (Table.ddl). This is to avoid SQL command conflicts when SQL reserved words are used as the column name. The numeric suffix is added when you run ejbdeploy command to generate deployment code for container managed persistence (CMP) entity beans.

List of SQL reserved keywords

Each of the database back end supported by the ejbdeploy command have their own list of SQL reserved keywords. The following list is the SQL reserved keywords for Informix® Dynamic Server V11:

ABSOLUTE
ACCESS
ADD
AFTER
AGGREGATE
ALL
ALLOCATE
ALTER
AND
ANY
APPEND
AS
ASC
AT
AUDIT
AUTHORIZATION
AVG
BEFORE
BEGIN
BETWEEN
BINARY
BOOLEAN
BOTH
BY
CACHE
CALL
CASCADE
CASE
CAST
CHAR
CHARACTER
CHECK
CLASS
CLOSE
CLUSTER
COBOL
COLLATION
COLLECTION
COLUMN
COMMIT
COMMITTED
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONSTRUCTOR
CONTINUE
COPY
COUNT
CREATE
CROSS
CURRENT
CURRENT_ROLE
CURSOR
CYCLE
DATABASE
DATE
DAY
DBA
DEALLOCATE
DEC
DECIMAL
DECLARE
DECODE
DEFAULT
DEFERRED
DEFINE
DELETE
DEREF
DESC
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DISCONNECT
DISTINCT
DOMAIN
DOUBLE
DROP
EACH
ELSE
END
ESCAPE
EXCEPTION
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXIT
EXPLAIN
EXPLICIT
EXTENT
EXTERNAL
FALSE
FETCH
FILE
FILLFACTOR
FIRST
FLOAT
FLUSH
FOR
FOREIGN
FORTRAN
FOUND
FREE
FROM
FULL
FUNCTION
GENERAL
GET
GLOBAL
GO
GOTO
GRANT
GROUP
HASH
HAVING
HOUR
IF
IMMEDIATE
IN
INCREMENT
INDEX
INDICATOR
INITCAP
INNER
INOUT
INSERT
INT
INTEGER
INTERVAL
INTO
IS
ISOLATION
JOIN
KEY
LANGUAGE
LAST
LEADING
LEFT
LEVEL
LIKE
LIMIT
LIST
LOAD
LOCAL
LOCATOR
LOCK
LOG
LONG
LOWER
LVARCHAR
MAX
MAXVALUE
MIN
MINUTE
MINVALUE
MODE
MODIFY
MODULE
MONEY
MONTH
NCHAR
NEW
NEXT
NO
NOCACHE
NOCYCLE
NOMAXVALUE
NOMINVALUE
NONE
NOORDER
NORMAL
NOT
NULL
NUMERIC
NVL
OF
OFF
OLD
ON
ONLINE
ONLY
OPEN
OPTION
OR
ORDER
OUT
OUTER
OUTPUT
PAGE
PARAMETER
PASCAL
PLI
PRECISION
PREPARE
PRIMARY
PRIOR
PRIVATE
PRIVILEGES
PROCEDURE
PUBLIC
RAISE
RANGE
RAW
READ
REAL
REF
REFERENCES
REFERENCING
REGISTER
RELATIVE
RELEASE
RENAME
REPEATABLE
REPLICATION
RESOURCE
RESTRICT
RESUME
RETURN
RETURNS
REUSE
REVOKE
RIGHT
ROLE
ROLLBACK
ROUTINE
ROW
ROWID
ROWS
SAVE
SCHEDULE
SCHEMA
SCROLL
SECOND
SECTION
SELECT
SEQUENCE
SERIALIZABLE
SESSION
SET
SHARE
SHORT
SIZE
SMALLINT
SOME
SPECIFIC
SQL
SQLCODE
SQLERROR
SQLSTATE
SQLWARNING
START
STATIC
STATISTICS
STOP
STORAGE
SUBSTR
SUBSTRING
SUM
SYNONYM
SYSTEM
TABLE
TEMP
THEN
TIME
TIMEOUT
TO
TRAILING
TRANSACTION
TRIGGER
TRIGGERS
TRIM
TRUE
TRUNCATE
TYPE
UNCOMMITTED
UNDER
UNION
UNIQUE
UNKNOWN
UNSIGNED
UPDATE
UPPER
USAGE
USER
USING
VALUE
VALUES
VARCHAR
VARIABLE
VARYING
VIEW
WHEN
WHENEVER
WHERE
WHILE
WITH
WITHOUT
WORK
WRITE
YEAR

Related reference
The ejbdeploy command
SQL reserved keywords