SQL/MX Programming Manual for Java

Contents

HP NonStop SQL/MX Programming Manual for Java—523726-003

Examples

Example 4-1. Coding Transaction Control Statements in an SQLJ Program 4-42

Example C-1. SampleDDL.sqlj—Creating Tables From an SQLJ Program C-2

Example C-2. SampleDML.sqlj—Inserting, Deleting, Updating, and Selecting

Data C-9

Example C-3. MultiThread1.sqlj—Threads With Explicit Execution Contexts C-13

Example C-4. MultiThread2.sqlj—Threads With Different Connection

Contexts C-16

Example C-5. StreamParcels.sqlj—Stream Access Mode C-19

Example C-6. StreamTimeout.sqlj—Stream Timeout Setting C-22

Example C-7. EmbeddedDelete.sqlj—Embedded DELETE C-25

Example C-8. EmbeddedUpdate.sqlj—Embedded UPDATE C-28

Example C-9. SetOnRollback.sqlj—Setting Column Values on Rollback C-31

Figures

Figure 1-1. SQLJ Translation and Customization Without Module Definition

Files 1-10

Figure 1-2. SQL Compilation of an Embedded Module Definition 1-15

Figure 1-3. SQLJ Translation and Customization With Module Definition

Files 1-18

Figure 1-4. Static SQLJ Execution Environment 1-20

Figure 1-5. Dynamic SQLJ Execution Environment 1-21

Figure 4-1. Effect of the -missingSQLObject Option 4-3

Figure 6-1. Packaging an SQLJ Application in a JAR File 6-5

Figure 6-2. Customizing Profiles in a JAR File Without Producing Module Definition

Files 6-8

Figure 6-3. Customizing Profiles in a JAR File and Producing Module Definition

Files 6-9

Figure 6-4.

Module Name Length 6-14

Tables

Table 2-1. Software Products Required for SQLJ Programs 2-1

Table 3-1. Input Assignability of Data Types 3-32

Table 3-2. Output Assignability of Data Types 3-35

Table 3-3. Optimal Data Type Mappings 3-37

Table 5-1. SQLJ Command-Line Options 5-11

Table 6-1. Module Management Naming 6-15

Table A-1. Embedded SQL/MX Statements A-8

Table B-1. ConnectionContext Variables Summary B-2

Table B-2. ConnectionContext Methods Summary B-2