Appendix D - Reserved Words and Keywords

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide >

Appendix D - Reserved Words and Keywords

Previous pageReturn to chapter overviewNext page

Reserved Words

The following is a list of reserved words in s-Server as of version 5.1.0.

ABS

EXPLAIN

PRIMARY

ALL

EXP_AVG

PROCEDURE

ALLOCATE

EXTERNAL

RANGE

ALLOW

EXTRACT

RANK

ALTER

FALSE

READS

ANALYZE

FETCH

REAL

AND

FILTER

RECURSIVE

ANY

FIRST_VALUE

REF

ARE

FLOAT

REFERENCES

ARRAY

FLOOR

REFERENCING

AS

FOR

REGR_AVGX

ASENSITIVE

FOREIGN

REGR_AVGY

ASYMMETRIC

FREE

REGR_COUNT

AT

FROM

REGR_INTERCEPT

ATOMIC

FULL

REGR_R2

AUTHORIZATION

FUNCTION

REGR_SLOPE

AVG

FUSION

REGR_SXX

BEGIN

GET

REGR_SXY

BETWEEN

GLOBAL

RELEASE

BIGINT

GRANT

RESPECT

BINARY

GROUP

RESULT

BIT

GROUPING

RETURN

BLOB

HAVING

RETURNS

BOOLEAN

HOLD

REVOKE

BOTH

HOUR

RIGHT

BY

IDENTITY

ROLLBACK

CALL

IGNORE

ROLLUP

CALLED

IMPORT

ROW

CARDINALITY

IN

ROWS

CASCADED

INDICATOR

ROW_NUMBER

CASE

INITCAP

SAVEPOINT

CAST

INNER

SCOPE

CEIL

INOUT

SCROLL

CEILING

INSENSITIVE

SEARCH

CHAR

INSERT

SECOND

CHARACTER

INT

SELECT

CHARACTER_LENGTH

INTEGER

SENSITIVE

CHAR_LENGTH

INTERSECT

SESSION_USER

CHECK

INTERSECTION

SET

CHECKPOINT

INTERVAL

SIMILAR

CLOB

INTO

SMALLINT

CLOSE

IS

SOME

CLUSTERED

JOIN

SORT

COALESCE

LANGUAGE

SPECIFIC

COLLATE

LARGE

SPECIFICTYPE

COLLECT

LAST_VALUE

SQL

COLUMN

LATERAL

SQLEXCEPTION

COMMIT

LEADING

SQLSTATE

CONDITION

LEFT

SQLWARNING

CONNECT

LIKE

SQRT

CONSTRAINT

LIMIT

START

CONVERT

LN

STATIC

CORR

LOCAL

STDDEV

CORRESPONDING

LOCALTIME

STDDEV_POP

COUNT

LOCALTIMESTAMP

STDDEV_SAMP

COVAR_POP

LOWER

STOP

COVAR_SAMP

MATCH

STREAM

CREATE

MAX

SUBMULTISET

CROSS

MEMBER

SUBSTRING

CUBE

MERGE

SUM

CUME_DIST

METHOD

SYMMETRIC

CURRENT

MIN

SYSTEM

CURRENT_CATALOG

MINUTE

SYSTEM_USER

CURRENT_DATE

MOD

TABLE

CURRENT_DEFAULT_TRANSFORM_GROUP

MODIFIES

TABLESAMPLE

CURRENT_PATH

MODULE

THEN

CURRENT_ROLE

MONTH

TIME

CURRENT_SCHEMA

MULTISET

TIMESTAMP

CURRENT_TIME

NATIONAL

TIMEZONE_HOUR

CURRENT_TIMESTAMP

NATURAL

TIMEZONE_MINUTE

CURRENT_TRANSFORM_GROUP_FOR_TYPE

NCHAR

TINYINT

CURRENT_USER

NCLOB

TO

CURSOR

NEW

TRAILING

CYCLE

NO

TRANSLATE

DATE

NODE

TRANSLATION

DAY

NONE

TREAT

DEALLOCATE

NORMALIZE

TRIGGER

DEC

NOT

TRIM

DECIMAL

NTH_VALUE

TRUE

DECLARE

NULL

TRUNCATE

DEFAULT

NULLIF

UESCAPE

DELETE

NUMERIC

UNION

DENSE_RANK

OCTET_LENGTH

UNIQUE

DEREF

OF

UNKNOWN

DESCRIBE

OLD

UNNEST

DETERMINISTIC

ON

UPDATE

DISALLOW

ONLY

UPPER

DISCONNECT

OPEN

USER

DISTINCT

OR

USING

DOUBLE

ORDER

VALUE

DROP

OUT

VALUES

DYNAMIC

OUTER

VARBINARY

EACH

OVER

VARCHAR

ELEMENT

OVERLAPS

VARYING

ELSE

OVERLAY

VAR_POP

END

PARAMETER

VAR_SAMP

END-EXEC

PARTITION

WHEN

ESCAPE

PERCENTILE_CONT

WHENEVER

EVERY

PERCENTILE_DISC

WHERE

EXCEPT

PERCENT_RANK

WIDTH_BUCKET

EXEC

POSITION

WINDOW

EXECUTE

POWER

WITH

EXISTS

PRECISION

WITHIN

EXP

PREPARE

WITHOUT

 

 

YEAR

Non-reserved Keywords

The following is a list of keywords that are not reserved words.

ABSOLUTE

GOTO

PUMP

ACTION

GRANTED

READ

ADA

HIERARCHY

REBUILD

ADD

HOLDDOWN

RELATIVE

ADMIN

IDENTIFIED

REMOVE

AFTER

IMMEDIATE

RENAME

ALWAYS

IMPLEMENTATION

REPEATABLE

ASC

INCLUDING

REPLACE

ASSERTION

INCREMENT

RESIDING

ASSIGNMENT

INDEX

RESPAWN

ATTRIBUTE

INITIALLY

RESTART

ATTRIBUTES

INPUT

RESTRICT

BASELINE

INSTALL

RETURNED_CARDINALITY

BEFORE

INSTANCE

RETURNED_LENGTH

BERNOULLI

INSTANTIABLE

RETURNED_OCTET_LENGTH

BREADTH

INVOKER

RETURNED_SQLSTATE

C

IPADDRESS

ROLE

CASCADE

ISOLATION

ROUTINE

CATALOG

JAR

ROUTINE_CATALOG

CATALOG_NAME

JAVA

ROUTINE_NAME

CHAIN

K

ROUTINE_SCHEMA

CHARACTERISTICTS

KEY

ROW_COUNT

CHARACTERS

KEY_MEMBER

SAMPLE

CHARACTER_SET_CATALOG

KEY_TYPE

SCALE

CHARACTER_SET_NAME

LABEL

SCHEMA

CHARACTER_SET_SCHEMA

LAST

SCHEMA_NAME

CLASS_ORIGIN

LENGTH

SCOPE_CATALOGS

CLOSED

LEVEL

SCOPE_NAME

CLOSING

LIBRARY

SCOPE_SCHEMA

COBOL

LINK

SECTION

COLLATION

LISTEN

SECURITY

COLLATION_CATALOG

LISTENER

SELF

COLLATION_NAME

LOCATOR

SEQUENCE

COLLATION_SCHEMA

M

SERIALIZABLE

COLUMNS

MAP

SERVER

COLUMN_NAME

MATCHED

SERVER_NAME

COMMAND_FUNCTION

MAXVALUE

SESSION

COMMAND_FUNCTION_CODE

MESSAGE_LENGTH

SETS

COMMITTED

MESSAGE_OCTET_LENGTH

SIMPLE

COMPUTE

MESSAGE_TEXT

SIZE

CONDITION_NUMBER

MINVALUE

SLEEP

CONNECTION

MORE

SOURCE

CONNECTION_NAME

MTU

SPACE

CONSTRAINTS

MULTIPLICAND

SPECIFIC_NAME

CONSTRAINT_CATALOG

MUMPS

SQLACTIONS

CONSTRAINT_NAME

NAME

STARTED

CONSTRAINT_SCHEMA

NAMES

STATE

CONSTRUCTOR

NESTING

STATEMENT

CONTAINS

NEXT

STATISTICS

CONTINUE

NORMALIZED

STOPPED

CONTROL

NULLABLE

STRUCTURE

CURSOR_NAME

NULLS

STYLE

DATA

NUMBER

SUBCLASS_ORIGIN

DATETIME_INTERVAL_CODE

OBJECT

SUBSTITUTE

DATETIME_INTERVAL_PRECISION

OCTETS

TABLE_NAME

DEFAULTS

OFFLINE

TCP

DEFERRABLE

ONLINE

TEMPORARY

DEFERRED

OPENING

TIES

DEFINED

OPTION

TIMEOUT

DEFINER

OPTIONS

TIMER

DEGREE

ORDERING

TOP_LEVEL_COUNT

DEPTH

ORDINALITY

TRANSACTION

DERIVED

OTHERS

TRANSACTIONS_ACTIVE

DESC

OUTPUT

TRANSACTIONS_COMMITTED

DESCRIPTION

OVERRIDING

TRANSACTIONS_ROLLED_BACK

DESCRIPTOR

PAD

TRANSFORM

DIAGNOSTICS

PARAMETER_MODE

TRANSFORMS

DISPATCH

PARAMETER_NAME

TRIGGER_CATALOG

DOMAIN

PARAMETER_ORDINAL_POSITION

TRIGGER_NAME

DOWN

PARAMETER_SPECIFIC_CATALOG

TRIGGER_SCHEMA

DRIVER

PARAMETER_SPECIFIC_NAME

TYPE

DYNAMIC_FUNCTION

PARAMETER_SPECIFIC_SCHEMA

UNBOUNDED

DYNAMIC_FUNCTION_CODE

PARTIAL

UNCOMMITTED

EQUALS

PASCAL

UNDER

ERROR

PASSTHROUGH

UNNAMED

ESTIMATE

PATH

UNPLANNABLE

EXCEPTION

PEER

UP

EXCLUDE

PERCENT

UPDATED

EXCLUDING

PING

USAGE

EXPEDITED

PLACING

USER_DEFINED_TYPE_CATALOG

FAIL

PLAN

USER_DEFINED_TYPE_CODE

FINAL

PLANNABLE

USER_DEFINED_TYPE_NAME

FIRST

PLI

USER_DEFINED_TYPE_SCHEMA

FOLLOWING

PORT

VERSION

FORTRAN

PRECEDING

VIEW

FOUND

PRESERVE

WORK

G

PRIOR

WRAPPER

GENERAL

PRIVILEGES

WRITE

GENERATED

PROCESSING

XML

GO

PUBLIC

ZONE