SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-35
Collations
Collations
NonStop SQL/MX does not support collations on character string columns, as NonStop
SQL/MP does. NonStop SQL/MX supports only the DEFAULT (binary) collation.
NonStop SQL/MX cannot access a column of an SQL/MP table that has a collation,
other than the default collation. If your SQL/MP application refers to an SQL/MP table
that has a collation, reconsider converting the application to NonStop SQL/MX, or
consider converting the SQL/MP table to an SQL/MX table that does not use collations.
For more information, see Section 11, Converting an SQL/MP Database to SQL/MX
Tables.
The COLLATE clause is disallowed in a GROUP BY clause or an ORDER BY clause
of a SELECT statement that queries an SQL/MP table. When converting an SQL/MP
application to an SQL/MX application, remove COLLATE clauses from SELECT
statements.
Date-Time Data Types and Literals
Both NonStop SQL/MP and NonStop SQL/MX support the SQL:1999 date-time data
types of DATE, TIME, and TIMESTAMP. Both NonStop SQL/MP and NonStop SQL/MX
support several nonstandard date-time types with specific start-end fields. However,
NonStop SQL/MX maps some date-time data types to DATE, TIME and TIMESTAMP
data types. NonStop SQL/MX does not support nonstandard date-time data types with
a start field of FRACTION.
Table 10-9
lists the mapping between date-time data types used in NonStop SQL/MP
and data types supported in NonStop SQL/MX. For information about how NonStop
SQL/MX processes nonstandard date-time data types, see the
SQL/MX Reference
Manual.
Selecting Supported DATETIME Columns
NonStop SQL/MX supports accessing any SQL/MP DATETIME column except those
consisting of FRACTION only.
Suppose that an SQL/MP table has a DATETIME column defined as:
MPDateTimeCol DATETIME MONTH TO DAY
DEFAULT DATETIME '03-12' MONTH TO DAY
In NonStop SQL/MX, you can select from this SQL/MP column as follows:
SELECT MPDateTimeCol FROM MPTable;
MPDateTimeCol
-------------
...
03-12
...