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

Converting an SQL/MP Database to SQL/MX Tables
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
11-4
Differences Between SQL/MP and SQL/MX
Databases
1. Splitting off the first half of the partition
2. Moving the second half to a new partition.
Unlike NonStop SQL/MP, which supports limited parallel updates, NonStop SQL/MX
does not currently perform partition-label updates in parallel.
Character Sets and Collations
NonStop SQL/MX does not currently support all the character sets that NonStop
SQL/MP supports, such as Big5 and ISO88592 through ISO88599. NonStop SQL/MX
supports only the DEFAULT collation in an SQL/MX table. For more information about
supported character sets in NonStop SQL/MX, see the
SQL/MX Reference Manual.
Load Capability in NonStop SQL/MX
In NonStop SQL/MP, you can use the SQLCI LOAD command to load data from an
SQL/MP table or a Guardian file into another SQL/MP table or its indexes. NonStop
SQL/MX has no equivalent command for loading data from an SQL/MX table or a
Guardian file into another SQL/MX table or its indexes. The SQL/MX
import utility
moves data from an input file in ASCII or UCS2 format or from a process such as
DataLoader/MX into an existing SQL/MX table. For more information about
import,
see the
SQL/MX Reference Manual and SQL/MX Installation and Management Guide.
Differences Between SQL/MP and SQL/MX
Databases
An SQL/MX database is similar to an SQL/MP database and has many of the same
features that are needed for distributed databases, database protection and recovery,
data integrity, database security, parallel processing, and high availability. However,
some differences exist between SQL/MP and SQL/MX databases for these entities:
•
System Catalogs and Metadata on page 11-5
•
User Catalogs and Schemas on page 11-6
•
Database Object Names on page 11-6
•
Distributed Database Objects on page 11-7
•
Database Object Security on page 11-7
•
Tables on page 11-8
•
Partitions on page 11-11
•
Indexes on page 11-12
•
Views on page 11-13
•
Collations on page 11-14