SQL/MX Programming Manual for Java

Contents
HP NonStop SQL/MX Programming Manual for Java—523726-003
iii
3. SQLJ Programming (continued)
3. SQLJ Programming (continued)
Data Type Support 3-32
Input Assignability 3-32
Output Assignability 3-35
Optimal Data Type Mappings 3-37
Date-Time Data Types 3-38
Interval Data Types 3-38
Floating-Point Data Types 3-39
Character String Data Types 3-40
Character String Literals 3-45
Using Special Characters in Character String Literals 3-45
Using Hexadecimal Values in Character String Literals 3-46
Specifying the Character Set Prefix 3-46
Specifying National Character String Literals 3-47
Iterators and Result Sets 3-48
Positioned Iterator 3-48
Named Iterator 3-51
Positioned Iterator Versus Named Iterator 3-54
Positioned UPDATE and DELETE Statements 3-55
Passing Iterators as Parameters 3-56
Converting Between SQLJ Iterators and JDBC Result Sets 3-56
Calling Stored Procedures in Java 3-59
Handling Exception Conditions 3-60
SQL Exceptions 3-60
Java Exceptions 3-62
SQL Warnings 3-63
Chained Exceptions and Warnings 3-64
Lost Open Error (8574) 3-66
4. SQL/MX Programming Considerations
Static and Dynamic SQL 4-1
Customized and Default Run Time 4-1
Static and Dynamic Execution Scenarios 4-2
Causes of Dynamic Execution 4-2