SQL/MX 2.x Reference Manual (H06.04+)

HP NonStop SQL/MX Reference Manual—540440-003
B-1
B Reserved Words
The words listed in this appendix are reserved for use by NonStop SQL/MX. To prevent
syntax errors, avoid using these words as identifiers in NonStop SQL/MP and in
NonStop SQL/MX. In NonStop SQL/MX, if a Guardian name contains a reserved word,
you must enclose the reserved word in double quotes (") to access that column or
object. See Using SQL/MX Reserved Words in SQL/MP Names on page 6-53.
In these lists, an asterisk (*) indicates reserved words that are SQL/MX extensions.
Words reserved by the ANSI standard are not marked.
Reserved SQL/MX and SQL/MP Identifiers
SQL/MX treats these words as reserved when they are part of SQL/MX text or
SQL/MP stored text. They cannot be used as identifiers unless you enclose them in
double quotes. SQL/MP stored text is SQL text that NonStop SQL/MX retrieves from
the SQL/MP catalog while processing SQL/MX text. SQL/MP stored text includes
views, constraints, column defaults, first keys, clustering keys, and partitioning keys.
Note. In SQL/MX Release 2.x, ABSOLUTE, DATA, EVERY, INITIALIZE, OPERATION, PATH,
STATE, STATEMENT, STATIC, and START are not reserved words.
Table B-1. Reserved SQL/MX and SQL/MP Identifiers (page 1 of 4)
ACTION FOR PROTOTYPE*
ADD FOREIGN PUBLIC
ADMIN FOUND READ
AFTER FRACTION* READS
AGGREGATE FREE REAL
ALIAS FROM RECURSIVE
ALL FULL REF
ALLOCATE FUNCTION REFERENCES
ALTER GENERAL REFERENCING
AND GET RELATIVE
ANY GLOBAL REPLACE*
ARE GO RESIGNAL*
ARRAY GOTO RESTRICT
AS GRANT RESULT
ASC GROUP RETURN
ASSERTION GROUPING RETURNS
ASYNC* HAVING REVOKE
AT HOST* RIGHT