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

Contents
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
xvii
2. SQL/MX Statements
Authorization and Availability Requirements 2-383
Example of UNREGISTER CATALOG 2-383
UPDATE Statement 2-384
Considerations for UPDATE 2-389
Use the EXPLAIN statement to check whether transactions will be rolled back
or if statement atomicity will be used. For details, see EXPLAIN Statement
on page 2-207. 2-389
Authorization Requirements 2-389
Transaction Initiation and Termination 2-390
Positioned UPDATE With AUTOCOMMIT 2-390
Isolation Levels of Transactions and Access Options of Statements 2-390
Conflicting Updates in Concurrent Applications 2-390
Requirements for Data in Row 2-391
Reporting of Updates 2-391
Updating Character Values 2-392
Audited and Nonaudited Tables 2-392
SET ON ROLLBACK Considerations 2-392
SET ON ROLLBACK Restrictions 2-392
Embedded SELECT UPDATE Behavior 2-393
Primary key restrictions 2-394
MXCI Examples of UPDATE 2-395
C Examples of UPDATE 2-399
COBOL Examples of UPDATE 2-399
Publish/Subscribe Examples of UPDATE 2-400
UPDATE STATISTICS Statement 2-401
Considerations for UPDATE STATISTICS 2-405
Physical Statistics
2-405
Using Statistics 2-405
Authorization and Locking 2-405
Transactions
2-406
Generating and Clearing Statistics for Columns
2-406
Column Lists and Access Plans 2-407
Sample Option
2-407
Sampling of Large Tables
2-407
Temporary Tables
2-408
Using Sample Table with Partitions
2-408
Managing SQL/MP Histograms 2-409
Examples of UPDATE STATISTICS
2-410
UPGRADE Utility
2-411