SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

Introduction

HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001

1-25

Partition Management

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

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

page 2-72 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-83 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. You 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-4.

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 the

SQL/MP Reference Manual.

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.

The areas of support and the restrictions on access are:

Naming Objects on

page 1-26

To refer to SQL/MP database objects, use either four-part

Guardian Physical Names

, three-part Logical Names, or

DEFINE Names

. To accommodate the use of ANSI names,

you must create Alias Mappings

from ANSI names to NSK

names.

Delimiting Reserved Words

in Guardian Names on

page 1-27

If a column or table name contains an SQL/MX reserved

word, you must delimit the reserved word in double quotes (").

Selecting or Changing Data

on page 1-28

You can select or change DATETIME Data, INTERVAL Data,

and NCHAR Data

with some restrictions.