SQL/MP Programming Manual for C

Contents
HP NonStop SQL/MP Programming Manual for C—429847-008
v
8. Program Invalidation and Automatic SQL
Recompilation (continued)
8. Program Invalidation and Automatic SQL
Recompilation (continued)
Run-Time Recompilation Errors 8-9
Preventing Automatic Recompilations 8-9
9. Error and Status Reporting
Using the INCLUDE STRUCTURES Directive 9-1
Generating Structures With Different Versions 9-3
Checking the Version of the C Compiler 9-3
Sharing Structures 9-3
Returning Error and Warning Information 9-4
Checking the sqlcode Variable 9-4
Using the WHENEVER Directive 9-6
Returning Information From the SQLCA Structure 9-12
Returning Performance and Statistics Information 9-13
Declaring the SQLSA Structure 9-13
Using the SQLSA Structure 9-13
10. Dynamic SQL Operations
Uses for Dynamic SQL 10-1
Dynamic SQL Statements 10-2
Dynamic SQL Features 10-3
SQLDA Structure, Names Buffer, and Collation Buffer 10-3
Input Parameters and Output Variables 10-11
Null Values 10-16
Dynamic Allocation of Memory
10-18
Using Dynamic SQL Cursors 10-20
Developing a Dynamic SQL Program
10-23
Specify the SQL Pragma 10-23
Copy any External Declarations
10-23
Declare the sqlcode Variable and Host Variables 10-23
Specify Any WHENEVER Directives
10-23
Specify the INCLUDE STRUCTURES Directive
10-24
Declare the SQLDA Structure and Names Buffer 10-24
Declare an SQLSA Structure
10-24
Process the Input Parameters
10-24
Read and Compile the SQL Statement
10-25
Process the Output Variables
10-25
Perform the Database Request and Display the Values 10-27