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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xiii
2. SQL/MX Statements
Manage Partitions of Range Partitioned Tables and Indexes 2-273
Manage Partitions of Hash Partitioned Tables and Indexes 2-280
Manage System-Clustered Tables 2-285
Managing a Sequence Generator 2-287
Renaming Guardian Location of Partitions of Tables, Indexes or Sequence
Generators 2-288
Considerations for MODIFY 2-289
Online Partition Management 2-290
Offline Partition Management for Range Partitions 2-291
Offline Partition Management for Hash Partitions 2-291
Offline Partition Management for System-Clustered Partitions 2-291
Offline Partition Management for Sequence Generators 2-291
Renaming Guardian Locations of Partitions of Tables, Indexes or Sequence
Generators 2-291
MODIFY and Indexes 2-292
MODIFY and TMF 2-292
MODIFY and RDF 2-293
MODIFY and Redefinition Timestamp 2-294
MODIFY and Table Reloading 2-294
Correcting File Name Problems with MODIFY 2-295
Examples of MODIFY 2-295
PREPARE Statement 2-298
Considerations for PREPARE 2-299
Availability of a Prepared Statement 2-299
Dynamic Parameters 2-299
Identifying Statements 2-299
Statement Names
2-300
MXCI Examples of PREPARE 2-300
C Examples of PREPARE 2-301
COBOL Examples of PREPARE
2-302
POPULATE INDEX Utility
2-303
Syntax Description of POPULATE INDEX 2-303
Considerations for POPULATE INDEX
2-304
Examples of POPULATE INDEX
2-305
PURGEDATA Utility
2-306
Syntax Description of PURGEDATA
2-306
Considerations for PURGEDATA 2-308
Examples of PURGEDATA
2-309
RECOVER Utility
2-310