![[Contents]](FIGURE/CONTENT.GIF)
Nonstop Database, HiRDB Version 9 SQL Reference
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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:
Table A-27 Reserved words that can be deleted (A)
| Reserved word | Disabled functionality |
|---|---|
| ABS | ![[Figure]](FIGURE/ZUENG030.GIF) Scalar function ABS |
| ALLOCATE | LOB attribute with abstract data type Plug-in |
| AMOUNT | -- |
| ANDNOT | Difference sets between lists |
| ANSI | -- |
| ARRAY | Repetition column |
| ASSERTION | -- |
| ASYNC | -- |
| AUTO | -- |
Table A-28 Reserved words that can be deleted (B)
| Reserved word | Disabled functionality |
|---|---|
| BASE | -- |
| BEGIN | Compound statements of routine control SQL statements User-defined function |
| BINARY | Data types BINARY, BINARY LARGE OBJECT |
| BIT_AND_TEST | Scalar function BIT_ADN_TEST |
| BLOB | Data type BLOB |
| BOOLEAN | Data type BOOLEAN |
| BOTH | -- |
| BREADTH | -- |
| BTREE | -- |
| BUFFER | -- |
| BYTE | -- |
Table A-29 Reserved words that can be deleted (C)
| Reserved word | Disabled functionality |
|---|---|
| CALL | Stored procedure Execution of a command or utility |
| CASE | CASE expression |
| CAST | CAST specification |
| COALESCE | CASE abbreviation |
| COLUMNS | -- |
| COMPLETION | -- |
| CONDITION | Conditional declaration of a routine control SQL compound statement |
| CONFIGURATION | -- |
| CONST | -- |
| CONSTRAINT | Referential constraint |
| CONTIGUOUS | -- |
| CORRESPONDING | -- |
| COUNT_FLOAT | COUNT_FLOAT set function |
| CROSS | -- |
| CURAID | -- |
| CURRENT_DATE | CURRENT_DATE value function DEFAULT clause |
| CURRENT_TIME | CURRENT_TIME value function DEFAULT clause |
| CURRENT_TIMESTAMP | CURRENT_TIMESTAMP value function DEFAULT clause |
| CURRENT_USER | -- |
| CYCLE | Sequence generator cycle option for the CREATE SEQUENCE statement |
Table A-30 Reserved words that can be deleted (D)
| Reserved word | Disabled functionality |
|---|---|
| DATA | Deleting an abstract data type |
| DATABASE | -- |
| DATE | Data type DATE Scalar function DATE CURRENT_DATE value function DEFAULT clause |
| DAY | Data type INTERVAL YEAR TO DAY Scalar function DAY Date operation |
| DAYS | Scalar function DAYS Date operation |
| DEFER | -- |
| DEMOTING | -- |
| DEPTH | -- |
| DEVICE | -- |
| DIAGNOSTICS | Embedded language syntax GET DIAGNOSTICS |
| DICTIONARY | -- |
| DIGITS | Scalar function DIGITS |
| DIRECT | -- |
| DO | Routine control SQL FOR statement, WHILE statement |
| DOUBLE_PRECISION | -- |
Table A-31 Reserved words that can be deleted (E)
| Reserved word | Disabled functionality |
|---|---|
| EACH | Trigger |
| EDIT | -- |
| ELSE | Routine control SQL IF statement |
| ELSEIF | Routine control SQL IF statement |
| ENCRYPT | -- |
| END | CASE expression Routine control SQL compound statement, FOR statement, IF statement, WHILE statement |
| EQUALS | -- |
| ESTIMATED | -- |
| EXCEPTION | Embedded language syntax GET DIAGNOSTICS |
| EXIT | Handler declaration for routine control SQL compound statement |
| EXTERN | -- |
| EXTRACT | -- |
Table A-32 Reserved words that can be deleted (F)
| Reserved word | Disabled functionality |
|---|---|
| FALSE | Boolen predicate IS FALSE |
| FIXED | -- |
| FORCE | -- |
| FREE | Data manipulation SQL FREE LOCATOR statement |
| FULL | -- |
| FUNCTION | User-defined function Plug-in Narrowing of audit trail based on object name |
Table A-33 Reserved words that can be deleted (G)
| Reserved word | Disabled functionality |
|---|---|
| GENERAL | -- |
| GET | Embedded language syntax GET DIAGNOSTICS |
| GET_JAVA_STORED_ROUTINE_SOURCE | Scalar function GET_JAVA_STORED_ROUTINE_SOURCE |
Table A-34 Reserved words that can be deleted (H)
| Reserved word | Disabled functionality |
|---|---|
| HANDLER | Routine control SQL handler declaration |
| HELP | -- |
| HEX | Scalar function HEX |
| HOUR | Data type INTERVAL HOUR TO SECOND Scalar function HOUR Time operation |
| HOURS | Time operation |
| HUGE | -- |
Table A-35 Reserved words that can be deleted (I)
| Reserved word | Disabled functionality |
|---|---|
| IF | Routine control SQL IF statement |
| IGNORE | -- |
| INNER | Join table INNER JOIN |
| INOUT | Stored procedure |
| INTERSECT | -- |
| INTERVAL | Data type INTERVAL HOUR TO SECOND, INTERVAL YEAR TO DAY Logging interval option for sequence generators (CREATE SEQUENCE statement) |
| ISOLATION | SQL compile option ISOLATION |
| IS_USER_CONTAINED_IN_HDS_GROUP | Scalar function IS_USER_CONTAINED_IN_HDS_GROUP |
Table A-36 Reserved words that can be deleted (L)
| Reserved word | Disabled functionality |
|---|---|
| LARGE | Data type LARGE DECIMAL, BINARY LARGE OBJECT |
| LEADING | -- |
| LEAVE | Routine control SQL LEAVE statement |
| LENGTH | Scalar function LENGTH SQL compile option SUBSTR LENGTH |
| LESS | -- |
| LEVEL | SQL compile options OPTIMIZE LEVEL, ADD OPTIMIZE LEVEL |
| LIMIT | LIMIT clause |
| LINES | -- |
| LINK | -- |
| LOCATOR | -- |
| LOCKS | -- |
| LOGID | -- |
| LOGNAME | -- |
| LOOP | -- |
| LOWER | Scalar function LOWER |
Table A-37 Reserved words that can be deleted (M)
| Reserved word | Disabled functionality |
|---|---|
| MAXUSAGES | -- |
| MINUTE | Scalar function MINUTE Time operation |
| MINUTES | Time operation |
| MOD | Scalar function MOD |
| MONTH | Scalar function MONTH Date operation |
| MONTHS | Date operation |
| MOVE | -- |
Table A-38 Reserved words that can be deleted (N)
| Reserved word | Disabled functionality |
|---|---|
| NATURAL | -- |
| NEW | Trigger |
| NOWAIT | Lock option NO WAIT |
| NULLIF | CASE abbreviation |
Table A-39 Reserved words that can be deleted (O)
| Reserved word | Disabled functionality |
|---|---|
| OFF | -- |
| OID | -- |
| OLD | Trigger |
| ONLY | Falsification-prevented table Read-only view table FOR READ ONLY |
| OPERATION | -- |
| OPERATORS | -- |
| OPTIMIZE | SQL compile options OPTIMIZE LEVEL, ADD OPTIMIZE LEVEL |
| OTHERS | -- |
| OUT | Stored procedure |
| OUTER | Join table OUTER JOIN |
| OVER | Window function |
| OVERFLOW | -- |
| OWN | -- |
Table A-40 Reserved words that can be deleted (P)
| Reserved word | Disabled functionality |
|---|---|
| PARAMETERS | -- |
| PENDANT | -- |
| PIC | -- |
| PICTURE | -- |
| PREALLOCATED | -- |
| PREFERRED | -- |
| PREORDER | -- |
| PRIVATE | Abstract data type |
| PROTECTED | Abstract data type |
| PURGE | Changing table partitioning conditions Definition SQL ALTER TABLE WITHOUT PURGE Data manipulation SQL PURGE TABLE statement |
Table A-41 Reserved words that can be deleted (R)
| Reserved word | Disabled functionality |
|---|---|
| RANDOM | -- |
| RD | -- |
| READ | Read-only view table FOR READ ONLY |
| RECOMPILE | -- |
| RECOVERABLE | -- |
| RECURSIVE | -- |
| REF | -- |
| REFERENCING | Trigger |
| REGLIKE | -- |
| RELEASING | -- |
| RESTART | -- |
| RETURN | User-defined function |
| RETURNS | User-defined function |
| RIGHT | -- |
| ROLE | -- |
| ROOT | -- |
| ROUTINE | Compiling a routine |
| ROW | Lock LOCK ROW by row Trigger (ROW specification) interface by row |
| ROWS | -- |
Table A-42 Reserved words that can be deleted (S)
| Reserved word | Disabled functionality |
|---|---|
| SAVEPOINT | -- |
| SCALE | -- |
| SCAN | -- |
| SCHEMAS | -- |
| SCOPE | -- |
| SD | -- |
| SEARCH | -- |
| SECOND | Data INTERVAL HOUR TO SECOND Scalar function SECOND Time operation |
| SECONDS | Time operation |
| SENSITIVE | -- |
| SEPARATE | -- |
| SEPARATOR | -- |
| SEQUENCE | CREATE SEQUENCE statement DROP SEQUENCE statement |
| SESSION_USER | -- |
| SFLIKE | -- |
| SHORT | -- |
| SIGNAL | Routine control SQL statement SIGNAL statement |
| SIMILAR | SIMILAR predicate |
| SLOCK | -- |
| SQL_STANDARD | -- |
| SQLCODE_OF_LAST_CONDITION | SQLCODE_OF_LAST_CONDITION value specification |
| SQLCODE_TYPE | -- |
| SQLDA | -- |
| SQLERRM | -- |
| SQLERRM_OF_LAST_CONDITION | SQLERRM_OF_LAST_CONDITION value specification |
| SQLERRMC | -- |
| SQLERRML | -- |
| SQLEXCEPTION | -- |
| SQLWARN | -- |
| STATIC | -- |
| STOP | -- |
| STOPPING | -- |
| SUBSTR | Scalar function SUBSTR SQL compile option SUBSTR LENGTH |
| SYSTEM_USER | -- |
Table A-43 Reserved words that can be deleted (T)
| Reserved word | Disabled functionality |
|---|---|
| TEST | -- |
| TEXT | -- |
| THEN | CASE expression Routine control SQL IF statement |
| THERE | -- |
| TIME | Data type TIME Scalar function TIME CURRENT_TIME value function DEFAULT clause default value |
| TIMESTAMP | Data type TIMESTAMP Scalar function TIMESTAMP CURRENT_TIMESTAMP value function DEFAULT clause default value |
| TIMESTAMP_FORMAT | Scalar function TIMESTAMP_FORMAT |
| TRAILING | -- |
| TRANSACTION | -- |
| TREAT | -- |
| TRIGGER | Trigger Narrowing of audit trail based on object name |
| TRIM | -- |
| TRUE | Boolean predicate IS TRUE |
| TYPE | Abstract data type Plug-in Narrowing of audit trail based on object name |
Table A-44 Reserved words that can be deleted (U)
| Reserved word | Disabled functionality |
|---|---|
| UAMT | -- |
| UBINBUF | -- |
| UCHAR | -- |
| UDATE | -- |
| UHANT | -- |
| UHDATE | -- |
| UNDER | Abstract data type |
| UNIFY_2000 | -- |
| UNIONALL | -- |
| UNKNOWN | Boolean predicate IS UNKNOWN |
| UNLIMITED | -- |
| UNLOCK | -- |
| UNTIL | UNTIL DISCONNECT |
| UPPER | Scalar function UPPER |
| USAGE | FOR PUBLIC USAGE sequence generator (CREATE SEQUENCE statement) |
| USE | -- |
| UTIME | -- |
| UTXTBUF | -- |
Table A-45 Reserved words that can be deleted (V)
| Reserved word | Disabled functionality |
|---|---|
| VALUE | Scalar function VALUE NEXT VALUE expression |
| VARCHAR_FORMAT | Scalar function VARCHAR_FORMAT |
| VARIABLE | -- |
| VARYING | Data types CHARACTER VARYING, NATIONAL CHARACTER VARYING |
| VIRTUAL | -- |
| VISIBLE | -- |
| VOLATILE | -- |
| VOLUME | -- |
| VOLUMES | -- |
Table A-46 Reserved words that can be deleted (W)
| Reserved word | Disabled functionality |
|---|---|
| WHEN | CASE expression Trigger |
| WHILE | Falsification-prevented table Routine control SQL WHILE statement |
Table A-47 Reserved words that can be deleted (X)
| Reserved word | Disabled functionality |
|---|---|
| XLOCK | -- |
| XML | XML type XML constructor function |
| XMLAGG | XMLAGG set function |
| XMLEXISTS | XMLEXISTS predicate |
| XMLPARSE | XMLPARSE function |
| XMLQUERY | XMLQUERY function |
| XMLSERIALIZE | XMLSERIALIZE function |
Table A-48 Reserved words that can be deleted (Y)
| Reserved word | Disabled functionality |
|---|---|
| YEAR | Data type INTERVAL YEAR TO DAY Scalar function YEAR Date operation |
| YEARS | Date operation |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.