Scalable Database Server, HiRDB Version 8 SQL Reference

[Contents][Index][Back][Next]

Appendix A.3 Reserved words that can be deleted using the SQL reserved word deletion facility

Tables A-27 to A-48 show the reserved words that can be deleted by using the SQL reserved word deletion facility, and the functionality that is disabled if a given reserved word is deleted.

The following legend is used in the tables:

[Figure]: There is no facility that is disabled when a reserved word is deleted.

Table A-27 Reserved words that can be deleted (A)

Reserved word Disabled functionality
ABS [Figure] Scalar function ABS
ALLOCATE [Figure] LOB attribute with abstract data type
[Figure] Plug-in
AMOUNT [Figure]
ANDNOT [Figure] Difference sets between lists
ANSI [Figure]
ARRAY [Figure] Repetition column
ASSERTION [Figure]
ASYNC [Figure]
AUTO [Figure]

Table A-28 Reserved words that can be deleted (B)

Reserved word Disabled functionality
BASE [Figure]
BEGIN [Figure] Compound statements of routine control SQL statements
[Figure] User-defined function
BINARY [Figure] Data types BINARY, BINARY LARGE OBJECT
BIT_AND_TEST [Figure] Scalar function BIT_ADN_TEST
BLOB [Figure] Data type BLOB
BOOLEAN [Figure] Data type BOOLEAN
BOTH [Figure]
BREADTH [Figure]
BTREE [Figure]
BUFFER [Figure]
BYTE [Figure]

Table A-29 Reserved words that can be deleted (C)

Reserved word Disabled functionality
CALL [Figure] Stored procedure
CASE [Figure] CASE expression
CAST [Figure] CAST specification
COALESCE [Figure] CASE abbreviation
COLUMNS [Figure]
COMPLETION [Figure]
CONDITION [Figure] Conditional declaration of a routine control SQL compound statement
CONFIGURATION [Figure]
CONST [Figure]
CONSTRAINT [Figure] Referential constraint
CONTIGUOUS [Figure]
CORRESPONDING [Figure]
CROSS [Figure]
CURAID [Figure]
CURRENT_DATE [Figure] CURRENT_DATE value function
[Figure] DEFAULT clause
CURRENT_TIME [Figure] CURRENT_TIME value function
[Figure] DEFAULT clause
CURRENT_TIMESTAMP [Figure] CURRENT_TIMESTAMP value function
[Figure] DEFAULT clause
CURRENT_USER [Figure]
CYCLE [Figure]

Table A-30 Reserved words that can be deleted (D)

Reserved word Disabled functionality
DATA [Figure] Deleting an abstract data type
DATABASE [Figure]
DATE [Figure] Data type DATE
[Figure] Scalar function DATE
[Figure] CURRENT_DATE value function
[Figure] DEFAULT clause
DAY [Figure] Data type INTERVAL YEAR TO DAY
[Figure] Scalar function DAY
[Figure] Date operation
DAYS [Figure] Scalar function DAYS
[Figure] Date operation
DEFER [Figure]
DEMOTING [Figure]
DEPTH [Figure]
DEVICE [Figure]
DIAGNOSTICS [Figure] Embedded language syntax GET DIAGNOSTICS
DICTIONARY [Figure]
DIGITS [Figure] Scalar function DIGITS
DIRECT [Figure]
DO [Figure] Routine control SQL FOR statement, WHILE statement
DOUBLE_PRECISION [Figure]

Table A-31 Reserved words that can be deleted (E)

Reserved word Disabled functionality
EACH [Figure] Trigger
EDIT [Figure]
ELSE [Figure] Routine control SQL IF statement
ELSEIF [Figure] Routine control SQL IF statement
ENCRYPT [Figure]
END [Figure] CASE expression
[Figure] Routine control SQL compound statement, FOR statement, IF statement, WHILE statement
EQUALS [Figure]
ESTIMATED [Figure]
EXCEPTION [Figure] Embedded language syntax GET DIAGNOSTICS
EXIT [Figure] Handler declaration for routine control SQL compound statement
EXTERN [Figure]
EXTRACT [Figure]

Table A-32 Reserved words that can be deleted (F)

Reserved word Disabled functionality
FALSE [Figure] Boolen predicate IS FALSE
FIXED [Figure]
FORCE [Figure]
FREE [Figure] Data manipulation SQL FREE LOCATOR statement
FULL [Figure]
FUNCTION [Figure] User-defined function
[Figure] Plug-in
[Figure] Narrowing of audit trail based on object name

Table A-33 Reserved words that can be deleted (G)

Reserved word Disabled functionality
GENERAL [Figure]
GET [Figure] Embedded language syntax GET DIAGNOSTICS
GET_JAVA_STORED_ROUTINE_SOURCE [Figure] Scalar function GET_JAVA_STORED_ROUTINE_SOURCE

Table A-34 Reserved words that can be deleted (H)

Reserved word Disabled functionality
HANDLER [Figure] Routine control SQL handler declaration
HELP [Figure]
HEX [Figure] Scalar function HEX
HOUR [Figure] Data type INTERVAL HOUR TO SECOND
[Figure] Scalar function HOUR
[Figure] Time operation
HOURS [Figure] Time operation
HUGE [Figure]

Table A-35 Reserved words that can be deleted (I)

Reserved word Disabled functionality
IF [Figure] Routine control SQL IF statement
IGNORE [Figure]
INNER [Figure] Join table INNER JOIN
INOUT [Figure] Stored procedure
INTERSECT [Figure]
INTERVAL [Figure] Data type INTERVAL HOUR TO SECOND, INTERVAL YEAR TO DAY
ISOLATION [Figure] SQL compile option ISOLATION
IS_USER_CONTAINED_IN_HDS_GROUP [Figure] Scalar function IS_USER_CONTAINED_IN_HDS_GROUP

Table A-36 Reserved words that can be deleted (L)

Reserved word Disabled functionality
LARGE [Figure] Data type LARGE DECIMAL, BINARY LARGE OBJECT
LEADING [Figure]
LEAVE [Figure] Routine control SQL LEAVE statement
LENGTH [Figure] Scalar function LENGTH
[Figure] SQL compile option SUBSTR LENGTH
LESS [Figure]
LEVEL [Figure] SQL compile options OPTIMIZE LEVEL, ADD OPTIMIZE LEVEL
LIMIT [Figure] LIMIT clause
LINES [Figure]
LINK [Figure]
LOCATOR [Figure]
LOCKS [Figure]
LOGID [Figure]
LOGNAME [Figure]
LOOP [Figure]
LOWER [Figure] Scalar function LOWER

Table A-37 Reserved words that can be deleted (M)

Reserved word Disabled functionality
MAXUSAGES [Figure]
MINUTE [Figure] Scalar function MINUTE
[Figure] Time operation
MINUTES [Figure] Time operation
MOD [Figure] Scalar function MOD
MONTH [Figure] Scalar function MONTH
[Figure] Date operation
MONTHS [Figure] Date operation
MOVE [Figure]

Table A-38 Reserved words that can be deleted (N)

Reserved word Disabled functionality
NATURAL [Figure]
NEW [Figure] Trigger
NOWAIT [Figure] Lock option NO WAIT
NULLIF [Figure] CASE abbreviation

Table A-39 Reserved words that can be deleted (O)

Reserved word Disabled functionality
OFF [Figure]
OID [Figure]
OLD [Figure] Trigger
ONLY [Figure] Falsification-prevented table
[Figure] Read-only view table
[Figure] FOR READ ONLY
OPERATION [Figure]
OPERATORS [Figure]
OPTIMIZE [Figure] SQL compile options OPTIMIZE LEVEL, ADD OPTIMIZE LEVEL
OTHERS [Figure]
OUT [Figure] Stored procedure
OUTER [Figure] Join table OUTER JOIN
OVER [Figure] Window function
OVERFLOW [Figure]
OWN [Figure]

Table A-40 Reserved words that can be deleted (P)

Reserved word Disabled functionality
PARAMETERS [Figure]
PENDANT [Figure]
PIC [Figure]
PICTURE [Figure]
PREALLOCATED [Figure]
PREFERRED [Figure]
PREORDER [Figure]
PRIVATE [Figure] Abstract data type
PROTECTED [Figure] Abstract data type
PURGE [Figure] Changing table partitioning conditions
[Figure] Definition SQL ALTER TABLE WITHOUT PURGE
[Figure] Data manipulation SQL PURGE TABLE statement

Table A-41 Reserved words that can be deleted (R)

Reserved word Disabled functionality
RANDOM [Figure]
RD [Figure]
READ [Figure] Read-only view table
[Figure] FOR READ ONLY
RECOMPILE [Figure]
RECOVERABLE [Figure]
RECURSIVE [Figure]
REF [Figure]
REFERENCING [Figure] Trigger
REGLIKE [Figure]
RELEASING [Figure]
RESTART [Figure]
RETURN [Figure] User-defined function
RETURNS [Figure] User-defined function
RIGHT [Figure]
ROLE [Figure]
ROOT [Figure]
ROUTINE [Figure] Compiling a routine
ROW [Figure] Lock LOCK ROW by row
[Figure] Trigger
[Figure] (ROW specification) interface by row
ROWS [Figure]

Table A-42 Reserved words that can be deleted (S)

Reserved word Disabled functionality
SAVEPOINT [Figure]
SCALE [Figure]
SCAN [Figure]
SCHEMAS [Figure]
SCOPE [Figure]
SD [Figure]
SEARCH [Figure]
SECOND [Figure] Data INTERVAL HOUR TO SECOND
[Figure] Scalar function SECOND
[Figure] Time operation
SECONDS [Figure] Time operation
SENSITIVE [Figure]
SEPARATE [Figure]
SEPARATOR [Figure]
SEQUENCE [Figure]
SESSION_USER [Figure]
SFLIKE [Figure]
SHORT [Figure]
SIGNAL [Figure] Routine control SQL statement SIGNAL statement
SIMILAR [Figure] SIMILAR predicate
SLOCK [Figure]
SQL_STANDARD [Figure]
SQLCODE_TYPE [Figure]
SQLDA [Figure]
SQLERRM [Figure]
SQLERRMC [Figure]
SQLERRML [Figure]
SQLEXCEPTION [Figure]
SQLWARN [Figure]
STATIC [Figure]
STOP [Figure]
STOPPING [Figure]
SUBSTR [Figure] Scalar function SUBSTR
[Figure] SQL compile option SUBSTR LENGTH
SYSTEM_USER [Figure]

Table A-43 Reserved words that can be deleted (T)

Reserved word Disabled functionality
TEST [Figure]
TEXT [Figure]
THEN [Figure] CASE expression
[Figure] Routine control SQL IF statement
THERE [Figure]
TIME [Figure] Data type TIME
[Figure] Scalar function TIME
[Figure] CURRENT_TIME value function
[Figure] DEFAULT clause default value
TIMESTAMP [Figure] Data type TIMESTAMP
[Figure] Scalar function TIMESTAMP
[Figure] CURRENT_TIMESTAMP value function
[Figure] DEFAULT clause default value
TIMESTAMP_FORMAT [Figure] Scalar function TIMESTAMP_FORMAT
TRAILING [Figure]
TRANSACTION [Figure]
TREAT [Figure]
TRIGGER [Figure] Trigger
[Figure] Narrowing of audit trail based on object name
TRIM [Figure]
TRUE [Figure] Boolean predicate IS TRUE
TYPE [Figure] Abstract data type
[Figure] Plug-in
[Figure] Foreign table
[Figure] Narrowing of audit trail based on object name

Table A-44 Reserved words that can be deleted (U)

Reserved word Disabled functionality
UAMT [Figure]
UBINBUF [Figure]
UCHAR [Figure]
UDATE [Figure]
UHANT [Figure]
UHDATE [Figure]
UNDER [Figure] Abstract data type
UNIFY_2000 [Figure]
UNIONALL [Figure]
UNKNOWN [Figure] Boolean predicate IS UNKNOWN
UNLIMITED [Figure]
UNLOCK [Figure]
UNTIL [Figure] UNTIL DISCONNECT
UPPER [Figure] Scalar function UPPER
USAGE [Figure]
USE [Figure]
UTIME [Figure]
UTXTBUF [Figure]

Table A-45 Reserved words that can be deleted (V)

Reserved word Disabled functionality
VALUE [Figure] Scalar function VALUE
VARCHAR_FORMAT [Figure] Scalar function VARCHAR_FORMAT
VARIABLE [Figure]
VARYING [Figure] Data types CHARACTER VARYING, NATIONAL CHARACTER VARYING
VIRTUAL [Figure]
VISIBLE [Figure]
VOLATILE [Figure]
VOLUME [Figure]
VOLUMES [Figure]

Table A-46 Reserved words that can be deleted (W)

Reserved word Disabled functionality
WHEN [Figure] CASE expression
[Figure] Trigger
WHILE [Figure] Falsification-prevented table
[Figure] Routine control SQL WHILE statement

Table A-47 Reserved words that can be deleted (X)

Reserved word Disabled functionality
XLOCK [Figure]

Table A-48 Reserved words that can be deleted (Y)

Reserved word Disabled functionality
YEAR [Figure] Data type INTERVAL YEAR TO DAY
[Figure] Scalar function YEAR
[Figure] Date operation
YEARS [Figure] Date operation

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.