Reference Guide > TDV SQL Support > Consolidated List of TDV Keywords
 
Consolidated List of TDV Keywords
The following table is a consolidated list of TDV keywords; that is, character strings that have special meaning for the TDV parser. The table lists both reserved and nonreserved keywords.
Reserved Keywords
Reserved keywords are listed in bold font in the table.
You cannot use reserved keywords as identifiers.
Reserved keywords are not case-sensitive.
If you want SQL statements to be portable across data sources, consult data source documentation for any additional reserved keywords they might have.
Nonreserved Keywords
Nonreserved keywords are listed in regular (nonbold) font in the table.
It is advisable not to use nonreserved keywords as identifiers.
If you choose to use a nonreserved keyword as an identifier, enclose it in double-quotes.
Nonreserved keywords used as identifiers are case-sensitive; for example, “Absent” and “absent” are considered different identifiers.
Nonreserved keywords used as keywords are not case-sensitive.
 
TDV Parser Keywords
ABSENT
ABSOLUTE
ACCORDING
ACTION
ADD
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
AT
AUTHORIZATION
AVG
BASE64
BEGIN
BETWEEN
BINARY
BIT
BIT_LENGTH
BOOLEAN
BOTH
BREADTH
BY
CALL
CASCADE
CASCADED
CASE
CAST
CATALOG
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CLOSE
COALESCE
COLLATE
COLLATION
COLLECTION
COLUMN
COLUMNS
COMMIT
CONNECT
CONNECTION
CONSTANT
CONSTRAINT
CONSTRAINTS
CONTENT
CONTINUE
CONVERT
CORRESPONDING
COUNT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CYCLE
D
DATE
DAY
DAYS
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DENSE_RANK
DEPTH
DESC
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DISCONNECT
DISTINCT
DO
DOCUMENT
DOMAIN
DOUBLE
DOW
DOY
DROP
ELEMENT
ELSE
ELSEIF
EMPTY
END
END-EXEC
EPOCH
ESCAPE
EXCEPT
EXCEPTION
EXCLUDE
EXEC
EXECUTE
EXISTS
EXPLAIN
EXTERNAL
EXTRACT
FALSE
FETCH
FIRST
FLOAT
FN
FOLLOWING
FOR
FOREIGN
FROM
FULL
GET
GLOBAL
GO
GOTO
GRANT
GROUP
HAVING
HEX
HOUR
HOURS
ID
IDENTITY
IF
IGNORE
IMMEDIATE
IN
INDEPENDENT
INDEX
INDICATOR
INITIALLY
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INT
INTEGER
INTERSECT
INTERVAL
INTO
IS
ISOLATION
ITERATE
JOIN
KEEP
KEY
LANGUAGE
LAST
LATEST
LEADING
LEAVE
LEFT
LEVEL
LIKE
LOCAL
LOCATION
LONGVARCHAR
LOOP
LOWER
MATCH
MAX
MICROSECOND
MICROSECONDS
MILLISECOND
MILLISECONDS
MIN
MINUTE
MINUTES
MODULE
MONTH
MONTHS
NAME
NAMES
NAMESPACE
NATIONAL
NATURAL
NCHAR
NEXT
NIL
NO
NOT
NULL
NULLIF
NULLS
NUMERIC
OCTET_LENGTH
OF
OFFSET
OJ
ON
ONLY
OPEN
OPTION
OR
ORDER
OTHERS
OUT
OUTER
OUTPUT
OVER
OVERLAPS
PAD
PARTIAL
PARTITION
PASSING
PATH
PIPE
POSITION
PRECEDING
PRECISION
PREPARE
PRESERVE
PRIMARY
PRIOR
PRIVILEGES
PROCEDURE
PUBLIC
QUARTER
RAISE
RANGE
READ
REAL
RECURSIVE
REF
REFERENCES
RELATIVE
REPEAT
REPLACE
RESTRICT
RETURNING
REVOKE
RIGHT
ROLLBACK
ROW
ROWS
SCHEMA
SCROLL
SEARCH
SECOND
SECONDS
SECTION
SELECT
SEQUENCE
SESSION
SESSION_USER
SET
SIZE
SMALLINT
SOME
SOURCE
SPACE
SQL
SQL_BIGINT
SQL_BINARY
SQL_BIT
SQL_CHAR
SQL_DATE
SQL_DECIMAL
SQL_DOUBLE
SQL_FLOAT
SQL_GUID
SQL_INTEGER
SQL_INTERVAL_DAY
SQL_INTERVAL_
DAY_TO_HOUR
SQL_INTERVAL_
DAY_TO_MINUTE
SQL_INTERVAL_
DAY_TO_SECOND
SQL_INTERVAL_HOUR
SQL_INTERVAL_
HOUR_TO_MINUTE
SQL_INTERVAL_
HOUR_TO_SECOND
SQL_INTERVAL_MINUTE
SQL_INTERVAL_
MINUTE_TO_SECOND
SQL_INTERVAL_MONTH
SQL_INTERVAL_SECOND
SQL_INTERVAL_YEAR
SQL_INTERVAL_
YEAR_TO_MONTH
SQL_LONGVARBINARY
SQL_LONGVARCHAR
SQL_NUMERIC
SQL_REAL
SQL_SMALLINT
SQL_TIME
SQL_TIMESTAMP
SQL_TINYINT
SQL_TSI_DAY
SQL_TSI_FRAC_SECOND
SQL_TSI_HOUR
SQL_TSI_MINUTE
SQL_TSI_MONTH
SQL_TSI_QUARTER
SQL_TSI_SECOND
SQL_TSI_WEEK
SQL_TSI_YEAR
SQL_VARBINARY
SQL_VARCHAR
SQL_WCHAR
SQL_WLONGVARCHAR
SQL_WVARCHAR
SQLCODE
SQLERROR
SQLSTATE
STRIP
SUBSTRING
SUM
SYSTEM_USER
T
TABLE
TEMPORARY
THEN
TIES
TIME
TIMESERIES
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TOP
TRAILING
TRANSACTION
TRANSLATE
TRANSLATION
TRIM
TRUE
TS
TYPE
UNBOUNDED
UNION
UNIQUE
UNKNOWN
UNTIL
UNTYPED
UPDATE
UPPER
URI
USAGE
USE
USER
USING
VALUE
VALUES
VARBINARY
VARCHAR
VARYING
VECTOR
VIEW
WEEK
WHEN
WHENEVER
WHERE
WHILE
WHITESPACE
WITH
WITHIN
WORK
WRITE
XML
XMLAGG
XMLATTRIBUTES
XMLBINARY
XMLCAST
XMLCOMMENT
XMLCONCAT
XMLDOCUMENT
XMLELEMENT
XMLEXISTS
XMLFOREST
XMLITERATE
XMLNAMESPACES
XMLPARSE
XMLPI
XMLQUERY
XMLSCHEMA
XMLSERIALIZE
XMLTABLE
XMLTEXT
XMLVALIDATE
YEAR
YEARS
ZONE