SQL/MX 2.x Reference Manual (H06.04+)
Introduction
HP NonStop SQL/MX Reference Manual—540440-003
1-31
SQL/MP File Organizations
°
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-60.
NonStop SQL/MX supports equivalent syntax for the UNITS operator. See Operations
Equivalent to UNITS on page 6-28.
SQL/MP File Organizations
An SQL/MP table can have one of three physical file organizations: key-sequenced,
entry-sequenced, or relative. You can access these type of SQL/MP files through
NonStop SQL/MX:
•
Key-sequenced tables with or without partitions
•
Entry-sequenced tables that are not partitioned
You cannot access these type of SQL/MP files through NonStop SQL/MX:
•
Entry-sequenced tables that are partitioned
•
Relative tables
For more information about SQL/MP file organizations, see the SQL/MP Reference
Manual.
Collations
In SQL/MP tables, character columns can be sequenced by specifying a collation in
the COLLATE clause of a column data type definition in a CREATE TABLE statement.
In NonStop SQL/MP, you create a collation with the CREATE COLLATION statement. If
you do not specify a COLLATE clause, SQL/MP character columns are sequenced by
the binary value of the characters in the column.
For SQL/MX Release 2.x, you cannot access any SQL/MP tables defined with
collations other than those tables defined with the default collation (consisting of the
binary value of characters in the column). Further, you cannot include the SQL/MP
COLLATE option in a GROUP BY clause or an ORDER BY clause when selecting from
an SQL/MP table.
For more information about collations, see the CREATE COLLATION Statement,
Collation Definitions, Data Types, and the COLLATE clause of the CREATE TABLE
Statement in the SQL/MP Reference Manual.