SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Introduction
HP NonStop SQL/MX Reference Manual—523725-004
1-29
SQL/MP Stored Text
SQL/MP Stored Text
You cannot access or manipulate SQL/MP tables or views that have been defined in
specific ways. There are restrictions on specific types of SQL/MP stored text, which 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.
In NonStop SQL/MX, these types of SQL/MP stored text are disallowed:
•
Views, constraints, column defaults, and first keys cannot contain:
°
UNITS function
°
DATETIME string portions with nonstandard formatting
°
FRACTION-only DATETIME or INTERVAL literals
°
Interval literals with negative signs inside quotation mark delimiters (for
example, INTERVAL '-5' DAY)
°
Identifiers named after words that are reserved in SQL/MP stored text (see
Appendix B, Reserved Words.)
Views, however, can contain a select of a FRACTION-only column.
•
Clustering or partitioning keys cannot contain:
°
FRACTION-only DATETIME or INTERVAL columns
°
Interval literals with negative signs inside quotation mark delimiters
°
Identifiers named after words that are reserved in SQL/MP stored text (see
Appendix B, Reserved Words.)
NonStop SQL/MX supports SQL/MP double-quoted string literals, which are treated
correctly as strings and not as SQL/MX delimited identifiers, in SQL/MP stored text.
NonStop SQL/MX supports SQL/MP character string literals that contain a space
between the character set qualifier and character string literal, such as
_KANJI 'abcd', in SQL/MP stored text. NonStop SQL/MX does not allow a space
after the character set qualifier in SQL/MX text. For example, you must specify
_KANJI'abcd'in SQL/MX text. See Character String Literals on page 6-62.
NonStop SQL/MX supports equivalent syntax for the UNITS operator. See Operations
Equivalent to UNITS on page 6-29.