SQL/MX Programming Manual for Java

Contents

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

viii

B. SQLJ Runtime Package (continued)

sqlj.runtime.ExecutionContext Class B-12

ExecutionContext Constructor Details B-13

ExecutionContext Method Details B-13

sqlj.runtime.CharacterStream Class B-16

CharacterStream Constructor Details B-16

sqlj.runtime.ref.DefaultContext Class B-18

DefaultContext Method Details B-18

C. Sample Programs

Using SQLJ Source Files C-1

Installing the sampleSQLJ.jar File C-1

Installing the SQL/MX Sample Database C-1

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

SQLJ Source File C-2

Translating the Program C-8

Running the Program C-8

Results of Running the Program C-8

SampleDML.sqlj—Inserting, Deleting, Updating, and Selecting Data C-9

SQLJ Source File C-9

Translating the Program C-11

Running the Program C-12

Results of Running the Program C-12

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

SQLJ Source File C-13

Translating the Program C-14

Running the Program C-14

Results of Running the Program C-15

MultiThread2.sqlj—Threads With Explicit Connection Contexts C-16

SQLJ Source File C-16

Translating the Program C-18

Running the Program C-18

Results of Running the Program C-18

StreamParcels.sqlj—Stream Access Mode C-19

SQLJ Source File C-19

Translating the Program C-20

Running the Program C-20

Results of Running the Program C-21