SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

MXCI Commands
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
4-89
Considerations for SHOWDDL
When displaying an SQL/MP view in SQL/MX syntax (not using SQLMP option),
you must manually remove correlated Guardian location names because they are
not valid SQL/MX syntax:
CREATE VIEW V1 ( N ) AS SELECT N FROM T1 T1 ;
•
Headings for SQL/MP views are not supported.
•
Added check not null constraints do not have accompanying "-- NOT NULL "
comments by columns that they determine are not null, as in the output for an
SQL/MX table. This situation is caused by differences in how NonStop SQL/MP
and NonStop SQL/MX implement NOT NULL constraints.
•
SHOWDDL does not display any table or column privilege information for the table.
•
If you do not specify the SQL/MP option, SHOWDDL displays the string constants
enclosed with single quotes.