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

Contents
HP NonStop SQL/MX Reference Manual—523725-004
xv
5. SQL/MX Utilities (continued)
5. SQL/MX Utilities (continued)
POPULATE INDEX Utility 5-69
Syntax Description of POPULATE INDEX 5-69
Considerations for POPULATE INDEX 5-69
Examples of POPULATE INDEX 5-71
PURGEDATA Utility 5-72
Syntax Description of PURGEDATA 5-72
Considerations for PURGEDATA 5-74
Examples of PURGEDATA 5-75
RECOVER Utility 5-76
Syntax Description of RECOVER 5-76
Considerations for RECOVER 5-77
Examples of RECOVER 5-77
VERIFY Operation 5-78
Considerations for VERIFY 5-79
Examples of VERIFY 5-80
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