Reserved words

A

ABS
ACCESS
ACTIVATE
AND
ANY
ARE
ARRAY
AS
ASC
ASENSITIVE
ASSOCIATE
ASUTIME
ASYMMETRIC
AT
ATOMIC
ATTRIBUTES
AUDIT
AUTHORIZATION
AUX
AUXILIARY
AVG

B

BACKUP
BEFORE
BEGIN
BETWEEN
BIGINT
BINARY
BLOB
BOOLEAN
BOTH
BREAK
BROWSE
BUFFERPOOL
BULK
BY

C

CACHE
CALL
CALLED
CAPTURE
CARDINALITY
CASCADE
CASCADED
CASE
CAST
CCSID
CEIL
CEILING
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CHECKPOINT
CLOB
CLONE
CLOSE
CLUSTER
CLUSTERED
COALESCE
COLLATE
COLLECT
COLLECTION
COLLID
COLUMN
COMMENT
COMMIT
COMPRESS
COMPUTE
CONCAT
CONDITION
CONNECT
CONNECTION
CONSTRAINT
CONTAINS
CONTAINSTABLE
CONTINUE
CONVERT
CORR
CORRESPONDING
COUNT
COUNT_BIG
COVAR_POP
COVAR_SAMP
CREATE
CROSS
CUBE
CUME_DIST
CURRENT
CURRENT_DATE
CURRENT_DEFAULT_TRANSFORM_GROUP
CURRENT_LC_CTYPE
CURRENT_PATH
CURRENT_ROLE
CURRENT_SCHEMA
CURRENT_SERVER
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIMEZONE
CURRENT_TRANSFORM_GROUP_FOR_TYPE
CURRENT_USER
CURSOR
CYCLEDATA

D

DATABASE
DATAPARTITIONNAME
DATAPARTITIONNUM
DATE
DAY
DAYS Db2.ENERAL Db2.ENRL Db2.QL
DBCC
DBINFO
DBPARTITIONNAME
DBPARTITIONNUM
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFAULTS
DEFINITION
DELETE
DENSE_RANK
DENSERANK
DENY
DEREF
DESC
DESCRIBE
DESCRIPTOR
DETERMINISTIC
DIAGNOSTICS
DISABLE
DISALLOW
DISCONNECT
DISK
DISTINCT
DISTRIBUTED
DO
DOCUMENT
DOUBLE
DROP
DSSIZE
DUMMY
DUMP
DYNAMIC

E

EACH
EDITPROC
ELEMENT
ELSE
ELSEIF
ENABLE
ENCODING
ENCRYPTION
END
END-EXEC
ENDING
ERASE
ERRLVL
ESCAPE
EVERY
EXCEPT
EXCEPTION
EXCLUDING
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXIT
EXP
EXPLAIN
EXTERNAL
EXTRACT

F

FALSE
FENCED
FETCH
FIELDPROC
FILE
FILLFACTOR
FILTER
FINAL
FLOAT
FLOOR
FOR
FOREIGN
FREE
FREETEXT
FREETEXTTABLE
FROM
FULL
FUNCTION
FUSION

G

GENERAL
GENERATED
GET
GLOBAL
GO
GOTO
GRANT
GRAPHIC
GROUP
GROUPINGHANDLER

H

HASH
HASHED_VALUE
HAVING
HINT
HOLD
HOLDLOCK
HOUR
HOURS

I

IDENTIFIED
IDENTITY
IDENTITY_INSERT
IDENTITYCOL
IF
IMMEDIATE
IN
INCLUDING
INCLUSIVE
INCREMENT
INDEX
INDICATOR
INF
INFINITY
INHERIT
INITIAL
INNER
INOUT
INSENSITIVE
INSERT
INT
INTEGER
INTEGRITY
INTERSECT
INTERSECTION
INTERVAL
INTO
IS
ISOBID
ISOLATION
ITERATE

J

JAR
JAVA
JOIN

K

KEEP
KEY
KILL

L

LABEL
LANGUAGE
LARGE
LATERAL
LC_CTYPE
LEADING
LEAVE
LEFT
LEVEL
LIKE
LINENO
LINKTYPE
LN
LOAD
LOCAL
LOCALDATE
LOCALE
LOCALTIME
LOCALTIMESTAMP
LOCATOR
LOCATORS
LOCK
LOCKMAX
LOCKSIZE
LONG
LOOP
LOWER

M

MAINTAINED
MATCH
MATERIALIZED
MAX
MAXEXTENTS
MAXVALUE
MEMBER
MERGE
METHOD
MICROSECOND
MICROSECONDS
MIN
MINUS
MINUTE
MINUTES
MINVALUE
MLSLABEL
MOD
MODE
MODIFIES
MODIFY
MODULE
MONTH
MONTHS
MULTISETNAN

N

NAN
NATIONAL
NATURAL
NCHAR
NCLOB
NEW
NEW_TABLE
NEXTVAL
NO
NOAUDIT
NOCACHE
NOCHECK
NOCOMPRESS
NOCYCLE
NODENAME
NODENUMBER
NOMAXVALUE
NOMINVALUE
NONCLUSTERED
NONE
NOORDER
NORMALIZE
NORMALIZED
NOT
NOWAIT
NULL
NULLIF
NULLS
NUMBER
NUMERIC
NUMPARTS

O

OBID
OCTET_LENGTH
OF
OFF
OFFLINE
OFFSETS
OLD
OLD_TABLE
ON
ONLINE
ONLY
OPEN
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
OPTIMIZATION
OPTIMIZE
OPTION
OPTION
OR
ORDER
OUT
OUTER
OVER
OVERLAPS
OVERLAY
OVERRIDING

P

PACKAGE
PADDED
PAGESIZE
PARAMETER
PART
PARTITION
PARTITIONED
PARTITIONING
PARTITIONS
PASSWORD
PATH
PCTFREE
PERCENT
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
PIECESIZE
PLAN
POSITION
POWER
PRECISION
PRIMARY
PRINT
PRIOR
PRIQTY
PRIVILEGES
PROC
PROCEDURE
PROGRAM
PSID
PUBLIC

Q

QUERY
QUERYNO

R

RAISERROR
RANGE
RANK
RAW
READ
READS
READTEXT
REAL
RECONFIGURE
RECOVERY
RECURSIVE
REF
REFERENCES
REFERENCING
REFRESH
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RELEASE
RENAME
REPEAT
REPLICATION
RESET
RESIGNAL
RESOURCE
RESTART
RESTORE
RESTRICT
RESULT
RESULT_SET_LOCATOR
RETURN
RETURNS
REVOKE
RIGHT
ROLE
ROLLBACK
ROLLUP
ROUND_CEILING
ROUND_DOWN
ROUND_FLOOR
ROUND_HALF_DOWN
ROUND_HALF_EVEN
ROUND_HALF_UP
ROUND_UP
ROUTINE
ROW
ROW_NUMBER
ROWCOUNT
ROWGUIDCOL
ROWID
ROWNUM
ROWNUMBER
ROWS
ROWSET
RRN
RULE
RUN

S

SAVE
SAVEPOINT
SCHEMA
SCOPE
SCRATCHPAD
SCROLL
SEARCH
SECOND
SECONDS
SECQTY
SECURITY
SELECT
SENSITIVE
SEQUENCE
SESSION
SESSION_USER
SET
SETUSER
SHARE
SHUTDOWN
SIGNAL
SIMILAR
SIMPLE
SIZE
SMALLINT
SNAN
SOME
SOURCE
SPECIFIC
SPECIFICTYPE
SQL
SQLEXCEPTION
SQLID
SQLSTATE
SQLWARNING
SQRT
STACKED
STANDARD
START
STARTING
STATEMENT
STATIC
STATISTICS
STATMENT
STAY
STDDEV_POP
STDDEV_SAMP
STOGROUP
STORES
STYLE
SUBMULTISET
SUBSTRING
SUCCESSFUL
SUM
SUMMARY
SYMMETRIC
SYNONYM
SYSDATE
SYSFUN
SYSIBM
SYSPROC
SYSTEM
SYSTEM_USER

T

TABLE
TABLESAMPLE
TABLESPACE
TEXTSIZE
THEN
TIME
TIMESTAMP
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TOP
TRAILING
TRAN
TRANSACTION
TRANSLATE
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TRUNCATE
TSEQUAL
TYPE

U

UESCAPE
UID
UNDO
UNION
UNIQUE
UNKNOWN
UNNEST
UNTIL
UPDATE
UPDATETEXT
UPPER
USAGE
USE
USER
USING

V

VALIDATE
VALIDPROC
VALUE
VALUES
VAR_POP
VAR_SAMP
VARCHAR
VARCHAR2
VARIABLE
VARIANT
VARYING
VCAT
VERSION
VIEW
VOLATILE
VOLUMES

W

WAITFOR
WHEN
WHENEVER
WHERE
WHILE
WIDTH_BUCKET
WINDOW
WITH
WITHIN
WITHOUT
WLM
WRITE
WRITETEXT

X

XMLELEMENT
XMLEXISTS
XMLNAMESPA

Parent topic: Managing data quality definitions