SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-70
Considerations for SHOWDDL
SQL/MP Conversion Issues
Note these syntax conversions when you are displaying DDL for an SQL/MP table:
•
If you run SHOWDDL on an MP alias, the MP alias name is displayed as the table
name unless you use the SQLMP option, in which case the SQL/MP table name is
displayed. SHOWDDL fully qualifies all SQL/MP aliases and fully expands SQL/MP
table names.
•
The LOCATION clause for SQL/MP tables is not displayed because it is invalid
syntax because its physical location name is not a valid SQL/MX location name.
•
The SMF logical name is displayed instead of the physical volume name
(PHYSVOL) for SQL/MP tables located on SMF volumes.
•
SHOWDDL does not display individual ALTER TABLE ADD COLUMN statements
for added columns in SQL/MP tables as they are for SQL/MX tables. The message
[-- This SQL/MP table contains user added columns --] is displayed before the DDL
of the table, and all columns are included in the DDL for the table.
•
NATIONAL CHAR (NCHAR) data type is converted into CHAR CHARACTER SET
using the default national character set.
•
Character sets that NonStop SQL/MP supports but NonStop SQL/MX does not
support are displayed by SHOWDDL, but the warning "*** WARNING[3010]
Character set ISO88599 is not yet supported." might be displayed.
•
The UNKNOWN character set in NonStop SQL/MP is converted into ISO88591 if
you do not specify the SQLMP option.
•
Only COLLATE DEFAULT is supported by NonStop SQL/MX. Other collations that
are supported by NonStop SQL/MP are displayed but are not valid for NonStop
SQL/MX.
•
The COLLATE statement must come last in an SQL/MP column definition or an
SQL/MP syntax error occurs, even though this is valid SQL/MP syntax. However,
this is not the order in which SHOWDDL outputs, so if you use SHOWDDL output
as input for NonStop SQL/MP you will receive this syntax error:
DEFAULT NULL is displayed after COLLATE.
•
FLOAT data type can be converted into equivalent REAL data types with a
precision value.
•
UPSHIFT is not displayed for PIC X data type.
•
For NUMERIC and SMALLINT data types, SIGNED does not appear because it is
the default. Only UNSIGNED is displayed.
•
DATETIME is not a supported data type in NonStop SQL/MX, but SHOWDDL
displays this data type for SQL/MP tables that contain it.
•
The largest MAXEXTENTS value for an SQL/MX table is 768, but it is 959 for
NonStop SQL/MP.