SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-74
Considerations for SHOWDDL
•
SHOWDDL always generates a Java signature for the SPJ.
•
SHOWDDL does not display the GRANT and REVOKE statements used to grant
or revoke any privileges on the table.
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 subvolume name and table name in the physical location of the SQL/MP table
are invalid for the SQL/MX syntax. If you do not specify the SQLMP option, only
system name and volume name of the SQL/MP physical location are displayed
with the location clause for SQL/MP tables.
•
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." is 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.