SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-2
Changes to SQL/MP Metadata
without the surrounding double quotes, and with two consecutive double quotes
collapsed into one double quote.
•
Unless otherwise stated, CHAR(n) in the data type field without a character set
qualifier is associated with the ISO88591 character set. All character types are
searched or sorted with the DEFAULT (binary) collation with the PAD SPACE
characteristic.
For SQL/MX Release 2.0, these tables are visible but are not supported and are
reserved for future use:
•
DDL_PARTITION_LOCKS
•
MODULES
•
MVGROUPS
•
MVS
•
MVS_COLS
•
MVS_JOIN_COLS
•
MVS_TABLE_INFO
•
MVS_USED
•
MVS_TABLE_INFO_UMD
•
MVS_USED_UMD
Changes to SQL/MP Metadata
For SQL/MX Release 2.0, SQL/MP metadata is changed from earlier product versions
of SQL/MX.
The SQL/MP MPALIAS table is still visible, but is no longer supported. You should not
drop this table, however, in case you need to fall back to a previous SQL/MX release.
The SQL/MX DEFAULTS table is still visible, but is no longer supported. You should
not drop this table, however, is case you need to fall back to a previous version.
The SQL/MP PROCS and PARAMS tables are no longer supported. If you have stored
procedures in installations that use releases of SQL/MX earlier than SQL/MX Release
2.0, you must register each of the procedures. For information on registering, see the
SQL/MX Guide to Stored Procedures in Java.
You must also use the MIGRATE utility to perform metadata migration to transfer
stored procedure information from the SQL/MX Release 1.8 PROCS and PARAMS
tables to the SQL/MX Release 2.0 system metadata tables. See migrate Utility on
page 5-38 for syntax, and the SQL/MX Installation and Management Guide for
migration steps.