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-13
Views
For more information about SQL/MX indexes, see the SQL/MX Reference Manual.
Views
In NonStop SQL/MX, use the SQL/MX CREATE VIEW statement to create ANSI views,
which have three-part ANSI names instead of Guardian physical names. The
distinction between SQL/MP protection and shorthand views does not exist in NonStop
SQL/MX. If a SQL/MX view is based on a single table, the view can be read, and
usually the view can be updated if it meets certain criteria. If a SQL/MX view is based
on multiple tables or other views, it can be read but not updated. For more information
about updatable and non-updatable views, see the
SQL/MX Reference Manual.
To create a SQL/MX view, you must have SELECT privileges for the database objects
underlying the view. In SQL/MX view definitions, you can use a UNION operator, but
you cannot use it in NonStop SQL/MP. You cannot refer to SQL/MP objects in SQL/MX
view definitions. The ALTER VIEW statement does not exist in NonStop SQL/MX. To
alter a SQL/MX view, you must use the DROP VIEW and CREATE VIEW statements,
respectively, to drop and then re-create the view.
NonStop SQL/MX handles security on views differently than NonStop SQL/MP. In
NonStop SQL/MP, you must have appropriate security on the underlying table of the
view to update the view. In NonStop SQL/MX, you need only have appropriate security
on the view itself, not on the underlying table, to update the view.
For more information about SQL/MX views, see the
SQL/MX Reference Manual.
Collations
Unlike NonStop SQL/MP, NonStop SQL/MX does not support collations other than the
DEFAULT collation, which uses binary ordering. In NonStop SQL/MX, you cannot
create collations, so the CREATE COLLATION statement does not exist in NonStop
SQL/MX. When you create a SQL/MX table, you can specify only DEFAULT in the
COLLATE clause of a character string column. For more information, see the
SQL/MX
Reference Manual.
ISLACK No
LOCKLENGTH No
MAXEXTENTS Yes
NOPURGEUNTIL No
SERIALWRITES No
SLACK No
TABLECODE No
VERIFIEDWRITES No
Table 5-4. Index Table Attributes in NonStop SQL/MP and NonStop
SQL/MX (page2of2)
SQL/MP Attributes Supported in SQL/MX?