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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 wordDisabled 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 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[Figure]

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