Reserved Words

Words which are used to mark the structure of query.

Reserved words (also known as keywords) are used to mark the structure of a query. As such, reserved words cannot be used as identifiers for any CCL objects. Identifiers that start with either XML or C8_ are also reserved.

ADAPTER

AFTER

ALL

AND

ANY

AS

ASC

ASCENDING

AT

ATTACH

BEFORE

BEGIN

BREAK

BY

CASE

COLUMNS

CONTINUE

CREATE

DATABASE

DAY

DAYS

DEFAULT

DELETE

DESC

DESCENDING

DISTINCT

DO

DOWN

ELSE

ELSEIF

END

EVERY

EXECUTE

FALSE

FOR

FROM

FULL

FUNCTION

GETBLOBCOLUMNBYNAME

GETBOOLEANCOLUMNBYNAME

GETFLOATCOLUMNBYNAME

GETINTEGERCOLUMNBYNAME

GETINTERVALCOLUMNBYNAME

GETLONGCOLUMNBYNAME

GETSTRINGCOLUMNBYNAME

GETTIMESTAMP

GETTIMESTAMPCOLUMNBYNAME

GETXMLCOLUMNBYNAME

GROUP

HAVING

HOUR

HOURS

IF

IMPORT

IN

INHERITS

INPUT

INSERT

INTO

IS

JOIN

KEEP

LARGEST

LAST

LEFT

LIKE

LIMIT

LOAD

LOCAL

MATCHING

MICROSECOND

MICROSECONDS

MILLISECOND

MILLISECONDS

MINUTE

MINUTES

MIRROR

MOD

MODULE

NO

NOT

NULL

OFFSET

ON

OR

ORDER

OTHERWISE

OUTER

OUTPUT

PARAMETER

PARAMETERS

PASSING

PER

PROCEDURE

PROPERTIES

QUERY

REGEXP_LIKE

REMOTE

RETURN

RETURNS

RIGHT

ROW

ROWS

SCHEMA

SECOND

SECONDS

SELECT

SET

SMALLEST

STARTING

STARTUP

STATEMENT

STREAM

STREAMS

THEN

TO

TRUE

UNGROUPED

UNTIL

UP

UPDATE

VARIABLE

WEEK

WEEKS

WHEN

WHERE

WHILE

WINDOW

WITHIN

XMLATTRIBUTES

XMLCOMMENT

XMLELEMENT

XMLEXISTS

XMLINSERT

XMLNAMESPACES

XMLPATTERNMATCH

XMLPI

XMLTABLE

XOR