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:

--: There is no facility that is disabled when a reserved word is deleted.

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

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

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

Reserved wordDisabled functionality
BASE--
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--
BREADTH--
BTREE--
BUFFER--
BYTE--

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

Reserved wordDisabled functionality
CALL[Figure]Stored procedure
[Figure]Execution of a command or utility
CASE[Figure]CASE expression
CAST[Figure]CAST specification
COALESCE[Figure]CASE abbreviation
COLUMNS--
COMPLETION--
CONDITION[Figure]Conditional declaration of a routine control SQL compound statement
CONFIGURATION--
CONST--
CONSTRAINT[Figure]Referential constraint
CONTIGUOUS--
CORRESPONDING--
COUNT_FLOAT[Figure]COUNT_FLOAT set function
CROSS--
CURAID--
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--
CYCLESequence generator cycle option for the CREATE SEQUENCE statement

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

Reserved wordDisabled functionality
DATA[Figure]Deleting an abstract data type
DATABASE--
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--
DEMOTING--
DEPTH--
DEVICE--
DIAGNOSTICS[Figure]Embedded language syntax GET DIAGNOSTICS
DICTIONARY--
DIGITS[Figure]Scalar function DIGITS
DIRECT--
DO[Figure]Routine control SQL FOR statement, WHILE statement
DOUBLE_PRECISION--

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

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

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

Reserved wordDisabled functionality
FALSE[Figure]Boolen predicate IS FALSE
FIXED--
FORCE--
FREE[Figure]Data manipulation SQL FREE LOCATOR statement
FULL--
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 wordDisabled functionality
GENERAL--
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 wordDisabled functionality
HANDLER[Figure]Routine control SQL handler declaration
HELP--
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--

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

Reserved wordDisabled functionality
IF[Figure]Routine control SQL IF statement
IGNORE--
INNER[Figure]Join table INNER JOIN
INOUT[Figure]Stored procedure
INTERSECT--
INTERVAL[Figure]Data type INTERVAL HOUR TO SECOND, INTERVAL YEAR TO DAY
[Figure] Logging interval option for sequence generators (CREATE SEQUENCE statement)
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 wordDisabled functionality
LARGE[Figure]Data type LARGE DECIMAL, BINARY LARGE OBJECT
LEADING--
LEAVE[Figure]Routine control SQL LEAVE statement
LENGTH[Figure]Scalar function LENGTH
[Figure] SQL compile option SUBSTR LENGTH
LESS--
LEVEL[Figure]SQL compile options OPTIMIZE LEVEL, ADD OPTIMIZE LEVEL
LIMIT[Figure]LIMIT clause
LINES--
LINK--
LOCATOR--
LOCKS--
LOGID--
LOGNAME--
LOOP--
LOWER[Figure]Scalar function LOWER

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

Reserved wordDisabled functionality
MAXUSAGES--
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--

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

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

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

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

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

Reserved wordDisabled functionality
PARAMETERS--
PENDANT--
PIC--
PICTURE--
PREALLOCATED--
PREFERRED--
PREORDER--
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 wordDisabled functionality
RANDOM--
RD--
READ[Figure]Read-only view table
[Figure]FOR READ ONLY
RECOMPILE--
RECOVERABLE--
RECURSIVE--
REF--
REFERENCING[Figure]Trigger
REGLIKE--
RELEASING--
RESTART--
RETURN[Figure]User-defined function
RETURNS[Figure]User-defined function
RIGHT--
ROLE--
ROOT--
ROUTINE[Figure]Compiling a routine
ROW[Figure]Lock LOCK ROW by row
[Figure]Trigger
[Figure](ROW specification) interface by row
ROWS--

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

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

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

Reserved wordDisabled functionality
TEST--
TEXT--
THEN[Figure]CASE expression
[Figure]Routine control SQL IF statement
THERE--
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--
TRANSACTION--
TREAT--
TRIGGER[Figure]Trigger
[Figure]Narrowing of audit trail based on object name
TRIM--
TRUE[Figure]Boolean predicate IS TRUE
TYPE[Figure]Abstract data type
[Figure]Plug-in
[Figure]Narrowing of audit trail based on object name

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

Reserved wordDisabled functionality
UAMT--
UBINBUF--
UCHAR--
UDATE--
UHANT--
UHDATE--
UNDER[Figure]Abstract data type
UNIFY_2000--
UNIONALL--
UNKNOWN[Figure]Boolean predicate IS UNKNOWN
UNLIMITED--
UNLOCK--
UNTIL[Figure]UNTIL DISCONNECT
UPPER[Figure]Scalar function UPPER
USAGE[Figure]FOR PUBLIC USAGE sequence generator (CREATE SEQUENCE statement)
USE--
UTIME--
UTXTBUF--

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

Reserved wordDisabled functionality
VALUE[Figure]Scalar function VALUE
[Figure] NEXT VALUE expression
VARCHAR_FORMAT[Figure]Scalar function VARCHAR_FORMAT
VARIABLE--
VARYING[Figure]Data types CHARACTER VARYING, NATIONAL CHARACTER VARYING
VIRTUAL--
VISIBLE--
VOLATILE--
VOLUME--
VOLUMES--

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

Reserved wordDisabled 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 wordDisabled functionality
XLOCK--
XML[Figure]XML type
[Figure]XML constructor function
XMLAGG[Figure]XMLAGG set function
XMLEXISTS[Figure]XMLEXISTS predicate
XMLPARSE[Figure]XMLPARSE function
XMLQUERY[Figure]XMLQUERY function
XMLSERIALIZE[Figure]XMLSERIALIZE function

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

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