SQL/MX Comparison Guide for SQL/MP Users

DML Features
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
3-5
Identifiers
Identifiers
NonStop SQL/MP supports only regular identifiers, formed from alphanumeric
characters and the underscore character. Regular identifiers are not case sensitive. In
NonStop SQL/MP, an SQL identifier can contain up to 30 letters (A through Z or a
through z), digits (0 through 9), or underscore (_) characters. The first character must
be a letter.
NonStop SQL/MX supports both regular and delimited identifiers. An identifier of either
type can contain up to 128 characters. Regular identifiers are defined as they are in
NonStop SQL/MP—with the exception of length. Delimited identifiers are character
strings that appear within double quote characters (") and consist of alphanumeric
characters and any character in the SQL-92 special character set except for the at sign
(@), the forward slash (/), backward slash (\), and circumflex (^).
For additional information about identifiers, see the SQL/MX Reference Manual.
Reserved Words
In NonStop SQL/MP, you should not use reserved words as names of constraints,
columns (including correlation names), cursors, or statements. You can, however, use
reserved words in catalog names, in Guardian names that identify tables, indexes,
views, partitions, collations, and in host variables.
NonStop SQL/MX reserves a longer list of words and allows the use of a reserved
word only if you place double quotes around it and observe case-sensitivity. You
cannot access views that are defined on tables named after reserved words. See the
SQL/MP Reference Manual for a list of SQL/MP reserved words. See the SQL/MX
Reference Manual for a list of SQL/MX reserved words. In addition, see the Identifiers
entry in the SQL/MX Reference Manual for information about how reserved words can
be used and limitations in NonStop SQL/MX.
Literals
NonStop SQL/MX uses single quote characters (') as character string delimiters.
NonStop SQL/MX supports all SQL/MP date-time literals. However, if you try to use a
literal with unsupported FRACTION-only INTERVAL or DATETIME in any sort of
expression, NonStop SQL/MX returns an error.
For additional information about literals, see the SQL/MX Reference Manual.
String Delimiters
NonStop SQL/MP uses both single (') and double quote characters (") to enclose
character, date-time, and interval literals. NonStop SQL/MX uses only single quote
characters for string delimiters, conforming to the SQL:1999 standard. NonStop
SQL/MX uses double quotes for delimited identifiers.