Appendix A.1 SQL reserved words

SQL includes reserved words defined in ISO as ISO 9075-1992 Database Language SQL (SQL 92) and reserved words defined in JIS as JIS X 3005-1990 Database Language SQL. The reserved words used in HiRDB are based on the JIS standards.

Reserved words are stored as keywords that are used in SQL statements. Therefore, reserved words cannot be used as table or column names.

A reserved word that appears in an SQL statement must be enclosed in quotation marks ("). When enclosed in quotation marks, a reserved word can be used as any character string.

Tables A-1 to A-25 show SQL reserved words.

For the tables, the following legends apply:

Y: Reserved word
[Figure]: Not a reserved word
SQL92: ISO SQL 1992
SQL99: ISO SQL 1999
UNIFY: UNIFY2000
XDM/RD: XDM/RD E2
HiRDB (V6): HiRDB Version 6
HiRDB (V7): HiRDB Version 7

Table A-1 SQL reserved words (A)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
ABS[Figure][Figure][Figure]YYY
ABSOLUTEYY[Figure][Figure]YY
ACCESS[Figure][Figure]Y[Figure]YY
ACTIONYY[Figure]YYY
ADDYYYYYY
ADMIN[Figure]Y[Figure][Figure][Figure][Figure]
AFTER[Figure]Y[Figure][Figure]YY
AGGREGATE[Figure]Y[Figure][Figure][Figure][Figure]
ALIAS[Figure]Y[Figure][Figure]YY
ALLYYYYYY
ALLOCATEYYYYYY
ALTERYYYYYY
AMOUNT[Figure][Figure]Y[Figure]YY
ANDYYYYYY
ANDNOT[Figure][Figure][Figure]YYY
ANSI[Figure][Figure]Y[Figure]YY
ANYYYYYYY
AREYY[Figure][Figure]YY
ARRAY[Figure]Y[Figure]YYY
ASYYYYYY
ASCYYYYYY
ASSERTIONYY[Figure][Figure]YY
ASSIGN[Figure][Figure][Figure]YYY
ASYNC[Figure][Figure][Figure][Figure]YY
ATYYY[Figure]YY
AUTHORIZATIONYYYYYY
AUTO[Figure][Figure]Y[Figure]YY
AVGY[Figure]YYYY

Table A-2 SQL reserved words (B)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
BASE[Figure][Figure]Y[Figure]YY
BEFORE[Figure]Y[Figure][Figure]YY
BEGINYYYYYY
BETWEENY[Figure]YYYY
BINARY[Figure]YYYYY
BITYY[Figure][Figure]YY
BIT_AND_TEST[Figure][Figure][Figure][Figure]YY
BIT_LENGTHY[Figure][Figure][Figure]YY
BLOB[Figure]Y[Figure]YYY
BOOLEAN[Figure]Y[Figure]YYY
BOTHYY[Figure]YYY
BREADTH[Figure]Y[Figure][Figure]YY
BTREE[Figure][Figure]Y[Figure]YY
BUFFER[Figure][Figure]Y[Figure]YY
BYYYYYYY
BYTE[Figure][Figure]Y[Figure]YY

Table A-3 SQL reserved words (C)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
CALL[Figure]Y[Figure]YYY
CASCADEYY[Figure][Figure]YY
CASCADEDYY[Figure][Figure][Figure][Figure]
CASEYY[Figure]YYY
CASTYY[Figure]YYY
CATALOGYY[Figure][Figure]YY
CHANGE[Figure][Figure][Figure]YYY
CHARYYYYYY
CHARACTERYYYYYY
CHAR_LENGTHY[Figure][Figure][Figure]YY
CHARACTER_LENGTHY[Figure][Figure][Figure]YY
CHECKYYYYYY
CLASS[Figure]Y[Figure][Figure][Figure][Figure]
CLOB[Figure]Y[Figure]Y[Figure][Figure]
CLOSEYYYYYY
CLUSTER[Figure][Figure][Figure]YYY
COALESCEY[Figure][Figure]YYY
COLLATEYY[Figure][Figure]YY
COLLATIONYY[Figure][Figure]YY
COLUMNYYYYYY
COLUMNS[Figure][Figure]Y[Figure]YY
COMMENT[Figure][Figure][Figure]YYY
COMMITYYYYYY
COMPLETION[Figure]Y[Figure][Figure]YY
COMPRESSED[Figure][Figure][Figure]Y[Figure][Figure]
CONDITION[Figure]Y[Figure][Figure][Figure]Y
CONFIGURATION[Figure][Figure]Y[Figure]YY
CONNECTYYYYYY
CONNECTIONYY[Figure][Figure]YY
CONST[Figure][Figure]Y[Figure]YY
CONSTRAINTYY[Figure]YYY
CONSTRAINTSYY[Figure][Figure]YY
CONSTRUCTOR[Figure]Y[Figure][Figure]YY
CONTIGUOUS[Figure][Figure]Y[Figure]YY
CONTINUEYYY[Figure]YY
CONVERTY[Figure][Figure][Figure]YY
CORR[Figure][Figure][Figure]Y[Figure][Figure]
CORRESPONDINGYY[Figure][Figure]YY
COUNTY[Figure]YYYY
COVAR_POP[Figure][Figure][Figure]Y[Figure][Figure]
COVAR_SAMP[Figure][Figure][Figure]Y[Figure][Figure]
CREATEYYYYYY
CROSSYY[Figure]YYY
CUBE[Figure]Y[Figure]Y[Figure][Figure]
CUME_DIST[Figure][Figure][Figure]Y[Figure][Figure]
CURAID[Figure][Figure]Y[Figure]YY
CURRENTYYYYYY
CURRENT_DATEYY[Figure]YYY
CURRENT_DEFAULT_TRANSFORM_GROUP[Figure]Y[Figure][Figure][Figure][Figure]
CURRENT_PATH[Figure]Y[Figure][Figure][Figure][Figure]
CURRENT_ROLL[Figure]Y[Figure][Figure][Figure][Figure]
CURRENT_TIMEYY[Figure]YYY
CURRENT_TIMESTAMPYY[Figure]YYY
CURRENT_TRANSFORM_GROUP_FOR_TYPE[Figure]Y[Figure][Figure][Figure][Figure]
CURRENT_USERYY[Figure]YYY
CURSORYYYYYY
CYCLE[Figure]Y[Figure][Figure]YY

Table A-4 SQL reserved words (D)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
DATA[Figure]YYYYY
DATABASE[Figure][Figure]Y[Figure]YY
DATEYYYYYY
DAYYY[Figure]YYY
DAYS[Figure][Figure][Figure]YYY
DBA[Figure][Figure]YYYY
DEALLOCATEYYY[Figure]YY
DECYYYYYY
DECIMALYYYYYY
DECLAREYYYYYY
DEFAULTYYYYYY
DEFER[Figure][Figure]Y[Figure]YY
DEFERRABLEYY[Figure][Figure]YY
DEFERREDYYY[Figure]YY
DELETEYYYYYY
DEMOTING[Figure][Figure]Y[Figure]YY
DENSE_RANK[Figure][Figure][Figure]Y[Figure][Figure]
DEPTH[Figure]Y[Figure][Figure]YY
DEREF[Figure]Y[Figure][Figure][Figure][Figure]
DESCYYYYYY
DESCRIBEYYYYYY
DESCRIPTION[Figure][Figure]Y[Figure][Figure][Figure]
DESCRIPTORYYYYYY
DESTROY[Figure]Y[Figure][Figure][Figure][Figure]
DESTRUCTOR[Figure]Y[Figure][Figure][Figure][Figure]
DETERMINISTIC[Figure]Y[Figure][Figure][Figure][Figure]
DEVICE[Figure][Figure]Y[Figure]YY
DIAGNOSTICSYY[Figure]YYY
DICTIONARY[Figure]Y[Figure][Figure]YY
DIGITS[Figure][Figure][Figure]YYY
DIRECT[Figure][Figure]Y[Figure]YY
DISCONNECTYYYYYY
DISPLAY[Figure][Figure]Y[Figure][Figure][Figure]
DISTINCTYYYYYY
DO[Figure]Y[Figure]YYY
DOMAINYY[Figure][Figure][Figure][Figure]
DOUBLEYYYYYY
DOUBLE_PRECISION[Figure][Figure]Y[Figure]YY
DROPYYYYYY
DYNAMIC[Figure]Y[Figure][Figure][Figure][Figure]

Table A-5 SQL reserved words (E)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
EACH[Figure]Y[Figure]YYY
EDIT[Figure][Figure]Y[Figure]YY
ELSEYY[Figure]YYY
ELSEIF[Figure]Y[Figure]YYY
ENCRYPT[Figure][Figure][Figure][Figure][Figure]Y
ENDYYYYYY
END-EXECYY[Figure][Figure][Figure][Figure]
EQUALS[Figure]Y[Figure][Figure]YY
ESCAPEYYYYYY
ESTIMATED[Figure][Figure]Y[Figure]YY
EVERY[Figure]Y[Figure]Y[Figure][Figure]
EXCEPTYY[Figure]YYY
EXCEPTIONYY[Figure]YYY
EXCLUSIVE[Figure][Figure][Figure]YYY
EXECYYY[Figure]YY
EXECUTEYYYYYY
EXISTSY[Figure]YYYY
EXIT[Figure]Y[Figure][Figure][Figure]Y
EXTERN[Figure][Figure]Y[Figure]YY
EXTERNALYY[Figure][Figure]YY
EXTRACTY[Figure][Figure][Figure]YY

Table A-6 SQL reserved words (F)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
FALSEYY[Figure]YYY
FETCHYYYYYY
FILE[Figure][Figure]Y[Figure]YY
FILTER[Figure][Figure][Figure]Y[Figure][Figure]
FIRSTYY[Figure][Figure]YY
FIX[Figure][Figure][Figure]YYY
FIXED[Figure][Figure]Y[Figure]YY
FLAT[Figure][Figure][Figure]YYY
FLOATYYYYYY
FORYYYYYY
FORCE[Figure][Figure]YYYY
FOREIGNYY[Figure]YYY
FOUNDYYY[Figure]YY
FREE[Figure]Y[Figure][Figure][Figure]Y
FROMYYYYYY
FULLYY[Figure]YYY
FUNCTION[Figure]Y[Figure]YYY

Table A-7 SQL reserved words (G)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
GENERAL[Figure]Y[Figure][Figure]YY
GETYYYYYY
GET_JAVA_STORED_ROUTINE_SOURCE[Figure][Figure][Figure][Figure]YY
GLOBALYY[Figure][Figure]YY
GOYYY[Figure]YY
GOTOYYY[Figure]YY
GRANTYYYYYY
GROUPYYYYYY
GROUPING[Figure]Y[Figure]Y[Figure][Figure]

Table A-8 SQL reserved words (H)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
HANDLER[Figure]Y[Figure][Figure][Figure]Y
HASH[Figure][Figure]Y[Figure]YY
HAVINGYYYYYY
HELP[Figure][Figure]Y[Figure]YY
HEX[Figure][Figure][Figure]YYY
HOST[Figure]Y[Figure][Figure][Figure][Figure]
HOURYY[Figure]YYY
HOURS[Figure][Figure][Figure]YYY
HUGE[Figure][Figure]Y[Figure]YY

Table A-9 SQL reserved words (I)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
IDENTIFIED[Figure][Figure][Figure]YYY
IDENTITYYY[Figure][Figure]YY
IF[Figure]Y[Figure]YYY
IGNORE[Figure]Y[Figure][Figure]YY
IMMEDIATEYYYYYY
INYYYYYY
INDEX[Figure][Figure]YYYY
INDICATORYYYYYY
INITIALIZE[Figure]Y[Figure][Figure][Figure][Figure]
INITIALLYYY[Figure][Figure]YY
INNERYY[Figure]YYY
INOUT[Figure]Y[Figure]YYY
INPUTYYY[Figure]YY
INSENSITIVEY[Figure][Figure][Figure]YY
INSERTYYYYYY
INTYYYYYY
INTEGERYYYYYY
INTERSECTYY[Figure]YYY
INTERVALYY[Figure]YYY
INTOYYYYYY
ISYYYYYY
ISOLATIONYY[Figure]YYY
IS_USER_CONTAINED_IN_HDS_GROUP[Figure][Figure][Figure][Figure]YY
ITERATE[Figure]Y[Figure]Y[Figure][Figure]

Table A-10 SQL reserved words (J)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
JOINYY[Figure]YYY

Table A-11 SQL reserved words (K)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
KEYYYYYYY

Table A-12 SQL reserved words (L)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
LABEL[Figure][Figure][Figure]Y[Figure][Figure]
LANGUAGEYYYYYY
LARGE[Figure]Y[Figure]YYY
LASTYY[Figure][Figure]YY
LATERAL[Figure]Y[Figure][Figure][Figure][Figure]
LEADINGYYYYYY
LEAVE[Figure]Y[Figure]YYY
LEFTYY[Figure][Figure]YY
LENGTH[Figure][Figure]YYYY
LESS[Figure]Y[Figure][Figure]YY
LEVELYYYYYY
LIKEYYYYYY
LIMIT[Figure]Y[Figure][Figure]YY
LINES[Figure][Figure]Y[Figure]YY
LINK[Figure][Figure]Y[Figure]YY
LIST[Figure][Figure][Figure]YYY
LOCALYY[Figure][Figure]YY
LOCALTIME[Figure]Y[Figure][Figure][Figure][Figure]
LOCALTIMESTAMP[Figure]Y[Figure][Figure][Figure][Figure]
LOCATOR[Figure]Y[Figure][Figure][Figure]Y
LOCK[Figure][Figure][Figure]YYY
LOCKS[Figure][Figure]Y[Figure]YY
LOGID[Figure][Figure]Y[Figure]YY
LOGNAME[Figure][Figure]Y[Figure]YY
LONG[Figure][Figure]YYYY
LOOP[Figure]Y[Figure]YYY
LOWERY[Figure][Figure]YYY

Table A-13 SQL reserved words (M)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
MAP[Figure]Y[Figure][Figure][Figure][Figure]
MATCHYY[Figure][Figure]YY
MAXY[Figure]YYYY
MAXUSAGES[Figure][Figure][Figure][Figure]YY
MCHAR[Figure][Figure][Figure]YYY
MICROSECOND[Figure][Figure][Figure]Y[Figure][Figure]
MICROSECONDS[Figure][Figure][Figure]Y[Figure][Figure]
MINY[Figure]YYYY
MINUTEYY[Figure]YYY
MINUTES[Figure][Figure][Figure]YYY
MOD[Figure][Figure][Figure]YYY
MODE[Figure][Figure]YYYY
MODIFIES[Figure]Y[Figure][Figure][Figure][Figure]
MODIFY[Figure]Y[Figure][Figure]YY
MODULEYYYYYY
MONTHYY[Figure]YYY
MONTHS[Figure][Figure][Figure]YYY
MOVE[Figure][Figure]Y[Figure]YY
MVARCHAR[Figure][Figure][Figure]YYY

Table A-14 SQL reserved words (N)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
NAMESYY[Figure][Figure]YY
NATIONALYY[Figure]YYY
NATURALYY[Figure][Figure]YY
NCHARYY[Figure]YYY
NCLOB[Figure]Y[Figure][Figure][Figure][Figure]
NESTING[Figure]Y[Figure][Figure][Figure][Figure]
NEW[Figure]Y[Figure]YYY
NEXTYY[Figure][Figure]YY
NOYY[Figure]YYY
NONE[Figure]Y[Figure][Figure]YY
NONLOCAL[Figure][Figure][Figure]Y[Figure][Figure]
NOTYYYYYY
NOWAIT[Figure][Figure][Figure]YYY
NULLYYYYYY
NULLABLE[Figure][Figure]Y[Figure]YY
NULLIFY[Figure][Figure]YYY
NUMERICYYYYYY
NVARCHAR[Figure][Figure][Figure]YYY

Table A-15 SQL reserved words (O)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
OBJECT[Figure]Y[Figure][Figure]YY
OCTET_LENGTHY[Figure][Figure][Figure]YY
OFYYYYYY
OFF[Figure]Y[Figure][Figure]YY
OFFSET[Figure][Figure]Y[Figure]YY
OID[Figure][Figure][Figure][Figure]YY
OLD[Figure]Y[Figure]YYY
ONYYYYYY
ONLYYYYYYY
OPENYYYYYY
OPERATION[Figure]Y[Figure][Figure]YY
OPERATORS[Figure][Figure][Figure][Figure]YY
OPTIONYYYYYY
OPTIMIZE[Figure][Figure][Figure]YYY
ORYYYYYY
ORDERYYYYYY
ORDINALITY[Figure]Y[Figure][Figure][Figure][Figure]
OTHERS[Figure][Figure][Figure][Figure]YY
OUT[Figure]Y[Figure]YYY
OUTERYY[Figure]YYY
OUTPUTYYY[Figure]YY
OVER[Figure][Figure](Changed to Y beginning in 2001)[Figure]Y[Figure]Y
OVERFLOW[Figure][Figure]Y[Figure]YY
OVERLAPSY[Figure][Figure][Figure][Figure][Figure]
OVERWRITE[Figure][Figure]Y[Figure][Figure][Figure]
OWN[Figure][Figure][Figure]YYY
OWNER[Figure][Figure]Y[Figure][Figure][Figure]

Table A-16 SQL reserved words (P)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
PADYY[Figure][Figure]YY
PAGE[Figure][Figure][Figure][Figure]YY
PARAMETER[Figure]Y[Figure][Figure][Figure][Figure]
PARAMETERS[Figure]Y[Figure][Figure]YY
PARTIALYY[Figure][Figure]YY
PARTITION[Figure][Figure][Figure]Y[Figure][Figure]
PARTITIONED[Figure][Figure][Figure][Figure]YY
PATH[Figure]YY[Figure][Figure][Figure]
PCTFREE[Figure][Figure][Figure]YYY
PENDANT[Figure][Figure][Figure][Figure]YY
PERCENT_RANK[Figure][Figure][Figure]Y[Figure][Figure]
PERCENTILE_CONT[Figure][Figure][Figure]Y[Figure][Figure]
PERCENTILE_DISC[Figure][Figure][Figure]Y[Figure][Figure]
PIC[Figure][Figure]Y[Figure]YY
PICTURE[Figure][Figure]YYYY
POSITIONY[Figure][Figure][Figure]YY
POSTFIX[Figure]Y[Figure][Figure][Figure][Figure]
PREALLOCATED[Figure][Figure]Y[Figure]YY
PRECISIONYYYYYY
PREFERRED[Figure][Figure]Y[Figure]YY
PREFIX[Figure]Y[Figure][Figure][Figure][Figure]
PREORDER[Figure]Y[Figure][Figure]YY
PREPAREYYYYYY
PRESERVEYY[Figure][Figure]YY
PRIMARYYYYYYY
PRIMLEGES[Figure][Figure]Y[Figure][Figure][Figure]
PRIORYY[Figure][Figure]YY
PRIVATE[Figure][Figure]YYYY
PRIVILEGESYY[Figure]YYY
PROCEDUREYYYYYY
PROGRAM[Figure][Figure][Figure]YYY
PROTECTED[Figure][Figure][Figure]YYY
PUBLICYYYYYY
PURGE[Figure][Figure][Figure]YYY

Table A-17 SQL reserved words (R)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
RANDOM[Figure][Figure][Figure][Figure]YY
RANGE[Figure][Figure][Figure]Y[Figure][Figure]
RANK[Figure][Figure][Figure]Y[Figure][Figure]
RD[Figure][Figure][Figure][Figure]YY
RDAREA[Figure][Figure][Figure]YYY
RDNODE[Figure][Figure][Figure]Y[Figure][Figure]
READYYYYYY
READS[Figure]Y[Figure][Figure][Figure][Figure]
REALYYYYYY
RECOMPILE[Figure][Figure][Figure][Figure]YY
RECOVERABLE[Figure][Figure]Y[Figure]YY
RECOVERY[Figure][Figure][Figure][Figure]YY
RECURSIVE[Figure]Y[Figure]YYY
REDO[Figure]Y[Figure][Figure][Figure][Figure]
REF[Figure]Y[Figure][Figure]YY
REFERENCESYYYYYY
REFERENCING[Figure]Y[Figure]YYY
REGLIKE[Figure][Figure]Y[Figure]YY
REGR_AVGX[Figure][Figure][Figure]Y[Figure][Figure]
REGR_AVGY[Figure][Figure][Figure]Y[Figure][Figure]
REGR_COUNT[Figure][Figure][Figure]Y[Figure][Figure]
REGR_INTERCEPT[Figure][Figure][Figure]Y[Figure][Figure]
REGR_R2[Figure][Figure][Figure]Y[Figure][Figure]
REGR_SLOPE[Figure][Figure][Figure]Y[Figure][Figure]
REGR_SXX[Figure][Figure][Figure]Y[Figure][Figure]
REGR_SXY[Figure][Figure][Figure]Y[Figure][Figure]
REGR_SYY[Figure][Figure][Figure]Y[Figure][Figure]
RELATIVEYY[Figure][Figure]YY
RELEASE[Figure][Figure][Figure]YYY
RELEASING[Figure][Figure]Y[Figure]YY
RENAME[Figure][Figure]Y[Figure]YY
REPEAT[Figure]Y[Figure]Y[Figure][Figure]
RESERVED[Figure][Figure][Figure]Y[Figure][Figure]
RESIGNAL[Figure]Y[Figure][Figure]YY
RESTART[Figure][Figure]Y[Figure]YY
RESTRICTYY[Figure][Figure]YY
RESULT[Figure]Y[Figure][Figure][Figure][Figure]
RETURN[Figure]Y[Figure]YYY
RETURNS[Figure]Y[Figure]YYY
REVOKEYYYYYY
RIGHTYY[Figure][Figure]YY
ROLE[Figure]Y[Figure][Figure]YY
ROLLBACKYYYYYY
ROLLUP[Figure]Y[Figure]Y[Figure][Figure]
ROOT[Figure][Figure]Y[Figure]YY
ROUTINE[Figure]Y[Figure]YYY
ROW[Figure]Y[Figure]YYY
ROW_NUMBER[Figure][Figure][Figure]Y[Figure][Figure]
ROWID[Figure][Figure]YYYY
ROWSYY[Figure]YYY

Table A-18 SQL reserved words (S)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
SAVEPOINT[Figure]Y[Figure][Figure]YY
SCALE[Figure][Figure]Y[Figure]YY
SCAN[Figure][Figure]Y[Figure]YY
SCATTERED[Figure][Figure]Y[Figure][Figure][Figure]
SCHEMAYYYYYY
SCHEMAS[Figure][Figure]Y[Figure]YY
SCOPE[Figure]Y[Figure][Figure]YY
SCROLLYY[Figure][Figure]YY
SD[Figure][Figure][Figure][Figure]YY
SEARCH[Figure]Y[Figure][Figure]YY
SECONDYY[Figure]YYY
SECONDS[Figure][Figure][Figure]YYY
SECTIONYYY[Figure]YY
SEGMENT[Figure][Figure]Y[Figure]YY
SELECTYYYYYY
SENSITIVE[Figure][Figure][Figure][Figure]YY
SEPARATE[Figure][Figure]Y[Figure]YY
SEPARATOR[Figure][Figure]Y[Figure]YY
SEQUENCE[Figure]Y[Figure][Figure]YY
SESSIONYY[Figure][Figure]YY
SESSION_USERYY[Figure][Figure]YY
SETYYYYYY
SETS[Figure]Y[Figure][Figure][Figure][Figure]
SFLIKE[Figure][Figure][Figure][Figure]YY
SHARE[Figure][Figure][Figure]YYY
SHLIKE[Figure][Figure]Y[Figure][Figure][Figure]
SHORT[Figure][Figure]Y[Figure]YY
SIGN[Figure][Figure]Y[Figure][Figure][Figure]
SIGNAL[Figure]Y[Figure]YYY
SIMILAR[Figure][Figure][Figure][Figure]YY
SIZEYYY[Figure]YY
SLOCK[Figure][Figure]Y[Figure]YY
SMALLFLT[Figure][Figure][Figure]YYY
SMALLINTYYYYYY
SOMEYYYYYY
SPACEYY[Figure][Figure]YY
SPECIFIC[Figure]Y[Figure]Y[Figure][Figure]
SPECIFICTYPE[Figure]Y[Figure][Figure][Figure][Figure]
SPLIT[Figure][Figure]Y[Figure]YY
SQLYYY[Figure]YY
SQL_STANDARD[Figure][Figure]Y[Figure]YY
SQLCODEY[Figure][Figure]YYY
SQLCODE_TYPE[Figure][Figure]Y[Figure]YY
SQLCOUNT[Figure][Figure][Figure]YYY
SQLDA[Figure][Figure][Figure]YYY
SQLERRM[Figure][Figure][Figure]YYY
SQLERRMC[Figure][Figure][Figure]YYY
SQLERRML[Figure][Figure][Figure]YYY
SQLERRORY[Figure]Y[Figure]YY
SQLEXCEPTION[Figure]Y[Figure][Figure]YY
SQLNAME[Figure][Figure][Figure]YYY
SQLSTATEYY[Figure]YYY
SQLWARN[Figure][Figure][Figure]YYY
SQLWARNING[Figure]YY[Figure]YY
START[Figure]YY[Figure]YY
STATE[Figure]Y[Figure][Figure][Figure][Figure]
STATEMENT[Figure]Y[Figure][Figure][Figure][Figure]
STATIC[Figure]YY[Figure]YY
STDDEV_POP[Figure][Figure][Figure]Y[Figure][Figure]
STOP[Figure][Figure]Y[Figure]YY
STOPPING[Figure][Figure][Figure]YYY
STRUCTURE[Figure]Y[Figure][Figure]YY
SUBSTR[Figure][Figure][Figure]YYY
SUBSTRINGY[Figure][Figure][Figure]YY
SUMY[Figure]YYYY
SUPPRESS[Figure][Figure][Figure][Figure]YY
SYNONYM[Figure][Figure]Y[Figure]YY
SYSTEM_USERYY[Figure][Figure]YY

Table A-19 SQL reserved words (T)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
TABLEYYYYYY
TABLES[Figure][Figure]Y[Figure][Figure][Figure]
TEMPORARYYY[Figure][Figure]YY
TERMINATE[Figure]Y[Figure][Figure][Figure][Figure]
TEST[Figure][Figure][Figure][Figure]YY
TEXT[Figure][Figure]Y[Figure]YY
THAN[Figure]Y[Figure][Figure][Figure][Figure]
THENYY[Figure]YYY
THERE[Figure][Figure][Figure][Figure]YY
TIMEYYYYYY
TIMESTAMPYY[Figure]YYY
TIMESTAMP_FORMAT[Figure][Figure][Figure][Figure][Figure]Y
TIMEZONE_HOURYY[Figure][Figure]YY
TIMEZONE_MINUTEYY[Figure][Figure]YY
TOYYYYYY
TRAILINGYY[Figure]YYY
TRANSACTIONYYY[Figure]YY
TRANSLATEY[Figure][Figure][Figure]YY
TRANSLATIONYY[Figure][Figure]YY
TREAT[Figure]Y[Figure][Figure]YY
TRIGGER[Figure]Y[Figure]YYY
TRIMY[Figure][Figure]YYY
TRUEYY[Figure]YYY
TYPE[Figure]YYYYY

Table A-20 SQL reserved words (U)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
UAMT[Figure][Figure]Y[Figure]YY
UBINBUF[Figure][Figure]Y[Figure]YY
UCHAR[Figure][Figure]Y[Figure]YY
UDATE[Figure][Figure]Y[Figure]YY
UHAMT[Figure][Figure]Y[Figure][Figure][Figure]
UHANT[Figure][Figure][Figure][Figure]YY
UHDATE[Figure][Figure]Y[Figure]YY
UNBOUNDED[Figure][Figure][Figure]Y[Figure][Figure]
UNDER[Figure]Y[Figure]YYY
UNDO[Figure]Y[Figure][Figure][Figure][Figure]
UNIFY_2000[Figure][Figure]Y[Figure]YY
UNIONYYYYYY
UNIONALL[Figure][Figure][Figure][Figure]YY
UNIQUEYYYYYY
UNKNOWNYY[Figure]YYY
UNLIMITED[Figure][Figure]Y[Figure]YY
UNLOCK[Figure][Figure]Y[Figure]YY
UNTIL[Figure]Y[Figure]YYY
UNNEST[Figure]Y[Figure][Figure][Figure][Figure]
UPDATEYYYYYY
UPPERY[Figure][Figure]YYY
USAGEYYYYYY
USE[Figure][Figure]Y[Figure]YY
USERYYYYYY
USER_GROUP[Figure][Figure][Figure]Y[Figure][Figure]
USER_LEVEL[Figure][Figure][Figure]Y[Figure][Figure]
USINGYYYYYY
UTIME[Figure][Figure]Y[Figure]YY
UTXTBUF[Figure][Figure]Y[Figure]YY

Table A-21 SQL reserved words (V)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
VALUEYYYYYY
VALUESYYYYYY
VAR_POP[Figure][Figure][Figure]Y[Figure][Figure]
VAR_SAMP[Figure][Figure][Figure]Y[Figure][Figure]
VARCHARYY[Figure]YYY
VARCHAR_FORMAT[Figure][Figure][Figure][Figure][Figure]Y
VARIABLE[Figure]Y[Figure][Figure]YY
VARYINGYY[Figure]YYY
VIEWYYYYYY
VIRTUAL[Figure][Figure][Figure][Figure]YY
VISIBLE[Figure][Figure][Figure][Figure]YY
VOLATILE[Figure][Figure]Y[Figure]YY
VOLUME[Figure][Figure]Y[Figure]YY
VOLUMES[Figure][Figure]Y[Figure]YY

Table A-22 SQL reserved words (W)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
WAIT[Figure][Figure][Figure]YYY
WHENYY[Figure]YYY
WHENEVERYYY[Figure]YY
WHEREYYYYYY
WHILE[Figure]Y[Figure]YYY
WINDOW[Figure][Figure][Figure]Y[Figure][Figure]
WITHYYYYYY
WITHIN[Figure][Figure][Figure]Y[Figure][Figure]
WITHOUT[Figure]Y[Figure]YYY
WORKYYYYYY
WRITEYYY[Figure]YY

Table A-23 SQL reserved words (X)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
XLIKE[Figure][Figure][Figure][Figure]YY
XLOCK[Figure][Figure]Y[Figure]YY

Table A-24 SQL reserved words (Y)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
YEARYY[Figure]YYY
YEARS[Figure][Figure][Figure]YYY

Table A-25 SQL reserved words (Z)

Reserved wordSQL92SQL99UNIFYXDM/RDHiRDB (V6)HiRDB (V7)
ZONE[Figure]Y[Figure][Figure][Figure][Figure]