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

Contents
HP NonStop SQL/MX Reference Manual—540440-003
xv
5. SQL/MX Utilities (continued)
5. SQL/MX Utilities (continued)
POPULATE INDEX Utility 5-73
Syntax Description of POPULATE INDEX 5-73
Considerations for POPULATE INDEX 5-73
Examples of POPULATE INDEX 5-75
PURGEDATA Utility 5-76
Syntax Description of PURGEDATA 5-76
Considerations for PURGEDATA 5-78
Examples of PURGEDATA 5-79
RECOVER Utility 5-80
Syntax Description of RECOVER 5-80
Considerations for RECOVER 5-81
Examples of RECOVER 5-81
VERIFY Operation 5-82
Considerations for VERIFY 5-83
Examples of VERIFY 5-84
6. SQL/MX Language Elements
Catalogs 6-2
SQL/MX Catalogs 6-2
SQL/MP Catalogs 6-2
Character Sets 6-3
Restrictions on Using Character Set Data 6-3
Collations 6-5
Columns 6-6
Column References 6-6
Derived Column Names 6-6
Column Default Settings 6-7
Examples of Derived Column Names 6-7
Constraints 6-8
Creating, Adding, and Dropping Constraints on SQL/MX Tables 6-8
Creating and Dropping Constraints on SQL/MP Tables 6-9
Correlation Names 6-10
Explicit Correlation Names 6-10
Implicit Correlation Names 6-10
Examples of Correlation Names 6-10
Database Objects 6-11
Ownership 6-11
Database Object Names 6-12