SQL Programming Manual for Pascal

Contents
HP NonStop SQL Programming Manual for Pascal—528614-001
v
6. Error and Status Processing (continued)
6. Error and Status Processing (continued)
Guidelines for Declaring the SQLDA 6-18
Data Type Literals 6-18
Example of Declaring the SQLDA 6-21
7. Using Dynamic SQL
Applications for Dynamic SQL 7-1
Developing a Dynamic SQL Application 7-2
Writing a Dynamic SQL Pathway Server 7-2
Specifying Input Parameters and Output Variables 7-4
Using the SQLDA and Names Buffer 7-5
Dynamic SQL Programming Techniques 7-7
Overview of a Dynamic SQL Program 7-8
Dynamically Allocating Memory 7-14
Using the Names Buffer 7-27
Handling Output Variables 7-30
Displaying Output 7-30
Using Dynamic Cursors 7-33
Using Statement and Cursor Host Variables 7-35
Handling Null Values 7-36
A. Sample NonStop SQL Database
Sample Database Source File A-2
B. Examples of Static NonStop SQL Programs
Insertion Program B-1
Date-Time Program B-6
C. Examples of Dynamic NonStop SQL Programs
Simple Dynamic SQL Program C-1
Detailed Dynamic SQL Program C-7
D. NonStop SQL Version Issues
Version 1 and Version 2 Definitions D-1
Summary of C30 Changes Incompatible With C10 D-3
Migrating an Application to Run on Release 2 (C30) D-4
Migrating an Application to Access Version 2 Objects D-7
Dynamic SQL and the SQLDA D-7
Recommendations for Installing Migrated Programs D-8
SQL Component Compatibility D-9