SQL/MX 2.x Reference Manual (H06.04+)

Introduction

HP NonStop SQL/MX Reference Manual—540440-003

1-23

Partition Management

You can create SQL/MX tables with multiple physical files, or partitions. Use the

CREATE TABLE Statement on page 2-74 and the CREATE INDEX Statement on

page 2-52 to create tables and indexes that include partitions. Use the MODIFY Utility

to partition tables after they have been created.

For more information, see Partitions on page 6-79 for an overview of partitions in

SQL/MX and SQL/MP files. For more information about managing partitioned files, see

the SQL/MX Installation and Management Guide.

Internationalization

Users need to be able to display data in formats appropriate to their locale and

language—in English or other Roman-character formats, in Japanese Kanji or Korean

or Chinese characters. In SQL/MX Release 2.x, users can select from one

single-character or three double-byte character sets. For more information about

character sets in addition to restrictions on the use of character sets, see Character

Sets on page 6-3.

Using NonStop SQL/MX to Access SQL/MP

Databases

NonStop SQL/MX allows applications to use the SQL/MX engine to access SQL/MP

databases. SQL/MP tables, views, indexes, and catalogs are accessed by using

SQL/MX DML statements. For more information on the SQL/MP language, see

theSQL/MP Reference Manual.

In SQL/MX Release 2.x, mixing embedded SQL calls to NonStop SQL/MP and

NonStop SQL/MX from the same application process is not supported.

NonStop SQL/MX provides support for nonstandard SQL/MP features so that you can

develop applications that use these databases. However, when you use NonStop

SQL/MX to access an SQL/MP database, you should be aware of some restrictions

involving SQL/MP features that do not directly map to NonStop SQL/MX.