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-9
Tables
For more information about SQL/MX file attributes, see the SQL/MX Reference
Manual.
Audited Tables Only
SQL/MP tables can be nonaudited 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.
DCOMPRESS No
EXTENT Yes
FORMAT No (SQL/MX tables are always format 2.)
ICOMPRESS No
LOCKLENGTH No
MAXEXTENTS Yes
NOPURGEUNTIL No
RECLENGTH No
TABLECODE No
VERIFIEDWRITES No
Table 11-1. File Attributes in NonStop SQL/MP and NonStop
SQL/MX (page 2 of 2)
SQL/MP Attributes Supported in SQL/MX?