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-87
Considerations for SHOWDDL
•
If there are two not null droppable constraints on the same user added column,
only one of these is displayed.
•
The ALLOCATE attribute is not stored in metadata or file label, so it is not
displayed.
•
The partitioning key is displayed only if it is different from the store by key. Such a
scenario is when SYSKEY is a part of the store by key but not a part of the
partitioning key, although the keys might appear to be the same because the
SYSKEY is not displayed by SHOWDDL.
•
SHOWDDL does not omit the optional clauses of the CREATE PROCEDURE
statement, such as LOCATION, CONTAINS SQL, NOT DETERMINISTIC, and NO
ISOLATE.
•
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.