SQL/MX Programming Manual for Java

Contents
HP NonStop SQL/MX Programming Manual for Java—523726-003
v
4. SQL/MX Programming
Considerations (continued)
4. SQL/MX Programming Considerations (continued)
Data Definition Language (DDL) Statements 4-32
Placement of DDL Statements 4-32
Scope of DDL Statements 4-32
Using Distributed Database Statements in an SQLJ Program 4-33
Distributing SQL/MX Objects From an SQLJ Program 4-35
Automatic Hash Partitioning From an SQLJ Program 4-37
Using SQL/MP Alias Statements in an SQLJ Program 4-38
UPDATE STATISTICS Statement 4-39
ANSI Compliance and Portability 4-39
Placement of the UPDATE STATISTICS Statement 4-39
Scope of the UPDATE STATISTICS Statement 4-39
Long-Running UPDATE STATISTICS Operations and TMF Errors 4-40
Publish/Subscribe Services 4-40
Transaction Management 4-41
Transaction Control Statements 4-41
Steps for Ensuring Data Consistency 4-42
Setting Attributes for Transactions 4-43
Starting a Transaction 4-46
Processing Database Changes 4-46
Testing for Errors 4-46
Committing Database Changes if No Errors Occur 4-47
Undoing Database Changes if an Error Occurs 4-47
5. Processing SQLJ Programs
Commands for Processing an SQLJ Program 5-1
Commands for Processing Without Module Definition Files 5-2
Commands for Processing With Module Definition Files 5-4
Using Command-Line Options 5-6
Prefixes, Options, and Flags 5-6
Properties File 5-7
Precedence of Option Settings 5-9