SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Tables to SQL/MX Tables
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
5-9
Tables
For more information about SQL/MX file attributes, see the SQL/MX Reference
Manual
.
Audited Tables Only
SQL/MP tables can be non-audited or audited, but all SQL/MX tables must be audited.
For more information, see the
SQL/MX Reference Manual.
Column Names
In SQL/MP tables, you cannot use a reserved word for a column name. However, in
SQL/MX tables, you can use a reserved word for a column name if you delimit the
reserved word by enclosing it in double quotes. For more information about delimited
identifiers and reserved words, see the
SQL/MX Reference Manual.
Column Data Types
SQL/MX tables support most of the data types that exist in SQL/MP tables, with a few
exceptions.
LOCKLENGTH No
MAXEXTENTS Yes
NOPURGEUNTIL No
RECLENGTH No
TABLECODE No
VERIFIEDWRITES No
Character String Columns Unlike SQL/MP tables, SQL/MX tables support only the
UCS2 or ISO88591 character set for character string
columns. NonStop SQL/MX does not support non-default
collations on SQL/MX character columns.
Date-Time Columns Many SQL/MP DATETIME data types map to SQL/MX
DATE, TIME, and TIMESTAMP data types. However,
NonStop SQL/MX does not support nonstandard date-time
data types with a start field of FRACTION. For more
information, see Table 4-9
on page 4-37.
Interval Columns Many SQL/MP interval data types map to SQL/MX interval
data types. However, NonStop SQL/MX does not support
interval data types with a start field of FRACTION. For
more information, see Table 4-10
on page 4-39.
Floating-Point Columns SQL/MX tables support floating-point columns that are in
IEEE floating-point format, not Tandem floating-point
format, which exists in SQL/MP tables.
Table 5-1. File Attributes in NonStop SQL/MP and NonStop SQL/MX (page2of2)
SQL/MP Attributes Supported in SQL/MX?