SQL reserved keywords for new functions of DB2 V8 for z/OS

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

The new function mode of DB2® v8 for z/OS® includes the generated data model that has all the new catalog features specified in the new function mode. Use this back-end option if you plan to work with the generated data model available in the IBM® Rational® Software Delivery Platform products.

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 new functions of DB2 v8 for z/OS:

ABSOLUTE
ACCESS
ACTION
ACTIVATE
ADA
ADD
AFTER
ALIAS
ALL
ALLOCATE
ALLOW
ALTER
ALTERIN
ALWAYS
AND
ANY
APPEND    
ARE
AS
ASC
ASCII
ASSERTION    
ASSOCIATE    
ASUTIME
AT
ATOMIC    
ATTRIBUTES
AUTHORIZATION    
AUTHID
AUTOMATIC    
AVG
BEFORE
BEGIN
BETWEEN    
BINARY
BIND
BINDADD
BIT
BIT_LENGTH
BLOB
BLOCKED
BOTH    
BUFFERPOOL
BUFFERPOOLS    
BY
C
CACHE
CALL
CALLED
CALLER
CAPTURE
CARDINALITY
CASCADE
CASCADED
CASE
CAST
CATALOG
CATALOG_NAME
CHANGE
CHANGED
CHANGES
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH    
CHECK
CHECKED    
CLIENT
CLOB
CLOSE
CLUSTER
COBOL    
COLLATE
COLLATION    
COLLECT
COLLID
COLUMN    
COMMENT
COMMIT
COMMITTED    
COMPARISONS
CONCAT
CONDITION
CONDITION_NUMBER
CONNECT
CONNECTION    
CONNECTION_NAME    
CONSERVATIVE
CONSTRAINT    
CONSTRAINTS    
CONTAINS
CONTINUE
CONTROL
CONVERT
COPY
CORRELATION
CORR
CORRESPONDING
COUNT
COUNT_BIG
CPU
C++
CREATE
CREATEIN    
CREATETAB
CROSS
CUBE
CURRENT
CURRENT_DATE    
CURRENT_PATH    
CURRENT_SCHEMA
CURRENT_SERVER
CURRENT_SQLID
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURRENT_USER    
CURSOR
CURSORS
CURSOR_NAME
CYCLE
DATE
DATA
DATABASE
DATALINK    
DAY
DAYS
DB
DBADM
DBCLOB
DBINFO
DB2DARI
DB2GENRL
DB2GENERAL    
DB2SQL
DEADLOCKS
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFAULTS
DEFINE
DEFINITION
DEGREE
DEFER
DEFERRABLE
DEFERRED
DELETE
DESC
DESCRIBE
DESCRIPTOR    
DETERMINISTIC    
DIAGNOSTICS
DIMENSIONS
DISABLE
DISALLOW
DISCONNECT
DISPATCH
DISTINCT    
DOMAIN
DO
DOUBLE
DROP
DROPIN    
DYNAMIC    
EACH
EBCDIC
ELSE
ELSEIF
EMPTY
ENABLE
END
END-EXEC
ERASE
ESCAPE
EUR    
EVENT
EXACT
EXCEPT
EXCEPTION
EXCLUDE
EXCLUDING
EXCLUSIVE
EXEC    
EXECUTE
EXISTS
EXIT    
EXPLAIN    
EXTENDED
EXTENSION    
EXTERNAL
EXTRACT
FALSE
FEDERATED
FENCED
FETCH
FILE    
FINAL
FIRST
FLOAT
FLUSH
FOLLOWING
FOR
FORCE
FOREIGN    
FORTRAN
FOUND
FREEPAGE
FROM
FS
FULL
FUNCTION
G
GBPCACHE
GENERAL
GENERATE
GENERATED
GET
GLOBAL
GO
GOTO
GRANT
GRAPHIC
GROUP
GROUPING
HANDLER    
HAVING      
HOLD
HOUR
HOURS
IDENTITY
IF
IMMEDIATE
IMPLICIT_SCHEMA
IN
INCLUDE
INCLUDING
INCREMENT    
INDEX
INDEXES
INDICATOR    
INHERIT
INITIALLY
INITIAL_INSTS
INITIAL_IOS    
INNER
INOUT
INPUT
INSENSITIVE
INSERT    
INSTEAD
INSTS_PER_ARGBYTE
INSTS_PER_INVOC
INT
INTEGER
INTEGRITY
INTERSECT
INTERVAL
INTO    
IOS_PER_ARGBYTE
IOS_PER_INVOC
IS
ISO
ITERATE
ISOLATION
JAVA    
JIS
JOIN
K
KEY
KEYS
LANGUAGE
LARGE
LAST
LEADING
LEAVE
LEFT
LENGTH
LEVEL
LIBRARY
LIKE
LIMIT
LINK
LINKTYPE
LOAD
LOCAL
LOCATOR
LOCATORS
LOCK
LOCKS
LOCKSIZE
LOGGED
LONG
LONGVAR
LOOP
LOWER
M
MAINTAINED    
MAPPING
MATCH
MAX    
MAXVALUE    
MESSAGE_TEXT
METHOD    
MICROSECOND
MICROSECONDS    
MINUTE
MINUTES
MINVALUE
MIXED
MODE
MODIFIES
MODULE
MONITOR
MONTH
MONTHS
MORE    
NAMED
NAMES
NATIONAL
NATURAL
NCHAR
NEW
NEW_TABLE
NEXT
NEXTVAL
NICKNAME
NO
NOCACHE
NOCYCLE
NODE    
NOMAXVALUE
NOMINVALUE    
NONE
NOORDER
NOT
NULL
NULLABLE    
NULLS    
NUMBER
NUMERIC    
OBJECT
OF
OFF
OLD
OLD_TABLE
OLE
OLEDB
ON
ONCE
ONLINE
ONLY
OPEN
OPTIMIZATION
OPTIMIZE
OPTION
OPTIONS
OR
ORDER
OUT
OUTER
OUTPUT
OVER    
OVERLAPS    
PACKAGE
PAD    
PARTIAL
PARALLEL    
PARAMETER
PASCAL
PASSTHRU
PASSWORD
PATH
PARTITION
PARTITIONING    
PCTFREE    
PERCENT_ARGBYTES
PERMISSION
PIECESIZE
PIPE
PLAN
PLI
POSITION
PRECEDING
PRECISION    
PREPARE
PRESERVE
PRIMARY    
PRIOR
PRIQTY
PRIVILEGES
PROCEDURE
PROGRAM    
PROTOCOL
PUBLIC
QUERY
QUERYNO    
RANGE    
READ
READS
REAL
RECOMMEND    
RECOVERY    
REF
REFERENCE
REFERENCES
REFERENCING
REFRESH
REGISTERS    
RELATIVE
RELEASE    
RENAME
REPEATABLE
REPEAT    
REPLACE
REPLICATED
RESET
RESIDENT
RESIGNAL    
RESOLVE
RESTART
RESTORE
RESTRICT
RESULT
RESULT_SET_LOCATOR    
RETURNED_SQLSTATE
RETAIN
RETURN
RETURNS
RETURN_STATUS  
REVOKE
RIGHT
ROLLBACK
ROLLUP
ROUTINE
ROW
ROW_COUNT
ROWID
ROWS
RUN
S    
SAVEPOINT
SBCS
SCALE    
SCHEMA    
SCOPE
SCRATCHPAD
SCROLL
SEARCH
SECOND
SECONDS
SECQTY
SECTION
SELECT    
SELECTIVITY
SELF
SEQUENCE
SERIALIZABLE
SERVER
SERVER_NAME
SESSION
SESSION_USER
SET
SETS    
SHARE
SHRLEVEL
SIGNAL
SIMPLE
SIZE
SMALLINT
SNAPSHOT
SOME
SOURCE
SPACE
SPECIAL
SPECIFIC    
SQL
SQLCODE
SQLERROR
SQLEXCEPTION
SQLWARNING
SQLID    
SQLSTATE    
START
STATE
STATEMENT    
STATISTICS
STAY
STOGROUP
STORAGE
STORED
STYLE
SUB    
SUBSTRING
SUMMARY
SWITCH
SYNONYM
SYSTEM
SYSTEM_USER
TABLE
TABLES
TABLE_NAME
TABLESPACE
TABLESPACES    
TEMPLATE
TEMPORARY
THEN
THREADSAFE    
TIME
TIMESTAMP
TIMEZONE
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRAILING
TRANSACTION    
TRANSFORM    
TRANSLATE
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TYPE
UNBOUNDED    
UNCOMMITTED
UNDER
UNDO
UNICODE
UNION
UNIQUE
UNKNOWN    
UNTIL    
UPDATE
UPPER
URL
USA
USE
USAGE
USER
USING
VALUE
VALUES
VARCHAR
VARGRAPHIC
VARIANT
VARYING
VCAT
VERSION
VIEW
VOLATILE
WHEN
WHENEVER
WHERE
WHILE
WITH
WITHOUT
WORK
WRAPPER
WRITE
YEAR
YEARS
YES    
ZONE


Feedback