SQL/MX Programming Manual for Java

Hewlett-Packard Company—523726-003
i
HP NonStop SQL/MX
Programming Manual for Java
Index Examples Figures Tables
What’s New in This Manual xiii
Manual Information xiii
New and Changed Information xiii
About This Manual xv
Audience xv
Organization xv
Examples in This Manual xvi
Related Documentation xvii
Notation Conventions xxi
1. Introduction
What Is SQLJ? 1-1
Benefits of SQLJ 1-1
SQLJ Compared With Embedded SQL in C or COBOL 1-2
SQLJ Compared With JDBC 1-4
SQLJ and JDBC Interoperability 1-5
SQLJ Versus JDBC Performance 1-6
Startup Performance 1-6
Steady-State Performance
1-7
When to Choose SQLJ Versus JDBC
1-7
Steps of Developing and Executing an SQLJ Program 1-8
Processing an SQLJ Program 1-9
Default Processing Without Module Definition Files 1-9
Processing With Module Definition Files 1-17
Executing an SQLJ Program 1-20
Static SQLJ Execution 1-20
Dynamic SQLJ Execution 1-21
Execution Scenarios 1-22