skip to main content
Part 3: The 32-Bit Drivers : The XML Driver : SQL Support : Grammar Token Definitions : Keywords for the XML Driver
  
Keywords for the XML Driver
A keyword may not be used as a regular identifier. For example, the following statement would generate a syntax error because INDICATOR is a keyword:
SELECT INDICATOR FROM T1
You can, however, enclose a keyword in double quotation marks to form a delimited identifier. For example, the following statement is valid:
SELECT "INDICATOR" FROM T1
The following table lists all of the keywords that are reserved for use in SQL statements or designated as potential future reserved words.
Table 65. Reserved Keywords
ABSOLUTE
ACTION
ADD
AFTER
ALIAS
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
ASYNC
AT
AUTHORIZATION
AVG
BEFORE
BEGIN
BETWEEN
BIT
BIT_LENGTH
BOOLEAN
BOTH
BREADTH
BY
CALL
CASCADE
CASCADED
CASE
CAST
CATALOG
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_ LENGTH
CHECK
CLOSE
COALESCE
COLLATE
COLLATION
COLUMN
COLUMNS
COMMIT
COMPLETION
CONCAT
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONTINUE
CONVERT
CORRESPONDING
COUNT
CREATE
CROSS
CURDATE
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_ TIMESTAMP
CURRENT_USER
CURSOR
CURTIME
CYCLE
DATA
DATE
DAY
DAYOFMONTH
DAYOFWEEK
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DEPTH
DESC
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DICTIONARY
DISCONNECT
DISTINCT
DOMAIN
DOUBLE
DROP
EACH
ELSE
ELSEIF
END
END_EXEC
EQUALS
ESCAPE
EXCEPT
EXCEPTION
EXEC
EXECUTE
EXISTS
EXTERNAL
EXTRACT
FALSE
FETCH
FIRST
FLOAT
FLOOR
FOR
FOREIGN
FOUND
FROM
FULL
GENERAL
GET
GLOBAL
GO
GOTO
GRANT
GROUP
HAVING
HOUR
IDENTIFY
IF
IFNULL
IGNORE
IMMEDIATE
IN
INDEX
INFO
INDICATOR
INITIALLY
INNER
INPUT
INSENSITIVE
INSERT
INT
INTEGER
INTERSECT
INTERVAL
INTO
IS
ISOLATION
JOIN
KEY
LANGUAGE
LAST
LCASE
LEADING
LEAVE
LEFT
LENGTH
LESS
LEVEL
LIKE
LIMIT
LOCAL
LOOP
LOWER
LTRIM
MATCH
MAX
MIN
MINUTE
MOD
MODIFY
MODULE
MONTH
NAMES
NATIONAL
NATURAL
NCHAR
NEW
NEXT
NO
NONE
NOT
NOW
NULL
NULLIF
NUMERIC
OBJECT
OCTET_LENGTH
OF
OFF
OID
OLD
ON
ONLY
OPEN
OPERATION
OPERATORS
OPTION
OR
ORDER
OTHERS
OUTER
OUTPUT
OVERLAPS
PAD
PARAMETERS
PARTIAL
PENDANT
POSITION
POWER
PRECISION
PREORDER
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIVATE
PRIVILEGES
PROCEDURE
PROTECTED
PUBLIC
RCASE
READ
REAL
RECURSIVE
REF
REFERENCES
REFERENCING
RELATIVE
REMOVE
REPLACE
RESIGNAL
RESTRICT
RETURN
RETURNS
REVOKE
RIGHT
ROLE
ROLLBACK
ROUND
ROUTINE
ROW
ROWS
RTRIM
SAVEPOINT
SCHEMA
SCROLL
SEARCH
SECOND
SECTION
SELECT
SENSITIVE
SEQUENCE
SESSION
SESSION_USER
SET
SIGNAL
SIMILAR
SIZE
SMALLINT
SOME
SPACE
SQL
SQLCODE
SQLERROR
SQLEXCEPTION
SQLSTATE
SQLWARNING
STRUCTURE
SUBSTRING
SUM
SYSTEM_USER
TABLE
TEMPORARY
TEST
THEN
THERE
TIME
TIMESTAMP
TIMEZONE_ HOUR
TIMEZONE_ MINUTE
TO
TRAILING
TRANSACTION
TRANSLATE
TRANSLATION
TRIGGER
TRIM
TRUE
TYPE
UCASE
UNDER
UNION
UNIQUE
UNKNOWN
UPDATE
UPPER
USAGE
USER
USING
VALUE
VALUES
VARCHAR
VARIABLE
VARYING
VIEW
VIRTUAL
VISIBLE
WAIT
WHEN
WHENEVER
WHERE
WHILE
WITH
WITHOUT
WORK
WRITE
YEAR
ZONE