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-8
Tables
Tables
A SQL/MX table is described in a SQL/MX schema yet stored in one or more physical
files in the Guardian environment. Unlike SQL/MP tables, which have Guardian
physical names, a SQL/MX table has an ANSI name of
catalog.schema.table,
where
catalog is the name of the catalog, schema is the name of the schema, and
table is the name of the table. SQL/MX tables also differ from SQL/MP tables in
these ways:

Physical File Organization on page 5-8

File Attributes on page 5-8

Audited Tables Only on page 5-9

Column Names on page 5-9

Column Data Types on page 5-9

Primary Keys on page 5-10

Clustering Keys on page 5-10

Constraints on page 5-10
Physical File Organization
SQL/MP tables can be relative, entry-sequenced, or key-sequenced tables. However,
SQL/MX tables can be only key-sequenced tables.
File Attributes
In SQL/MX tables, you can set some of the SQL/MP file attributes, as described in
Table 5-1
.
Table 5-1. File Attributes in NonStop SQL/MP and NonStop SQL/MX (page1of2)
SQL/MP Attributes Supported in SQL/MX?
ALLOCATE Yes
AUDIT No
AUDITCOMPRESS Yes
BLOCKSIZE Yes (only 4096)
BUFFERED No
CLEARONPURGE Yes
DCOMPRESS No
EXTENT Yes
FORMAT No (SQL/MX tables are always format 2.)
ICOMPRESS No