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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xxviii
6. SQL/MX Language Elements
MXRPM tool 5-75
Guidelines for map-file 5-76
Guidelines for module-list-input-file 5-76
Guidelines for log-file 5-76
Considerations 5-77
mxtool Utility 5-78
VERIFY Operation 5-79
Considerations for VERIFY 5-80
Security Considerations 5-81
Examples of VERIFY 5-82
6. SQL/MX Language Elements
Catalogs 6-3
SQL/MX Catalogs 6-3
SQL/MP Catalogs 6-3
Character Sets 6-4
Restrictions on Using Character Set Data 6-4
Collations 6-6
Columns 6-7
Column References 6-7
Derived Column Names 6-7
Column Default Settings 6-8
Examples of Derived Column Names 6-8
Constraints 6-9
Creating, Adding, and Dropping Constraints on SQL/MX Tables 6-9
Constraint Names
6-10
Restrictions on Publish/Subscribe
6-10
Creating and Dropping Constraints on SQL/MP Tables
6-10
Correlation Names 6-11
Explicit Correlation Names 6-11
Implicit Correlation Names
6-11
Examples of Correlation Names
6-11
Database Objects 6-12
Ownership
6-12
Database Object Names
6-13
Logical Names for SQL/MX Objects
6-13
Physical Names for SQL/MP Objects
6-13
Logical Names for SQL/MP Objects 6-14
DEFINE Names for SQL/MP Objects
6-14