SQL Programming Manual for TAL

Contents

HP NonStop SQL Programming Manual for TAL—527887-001

7. Dynamic NonStop SQL Operations

Determining Uses for Dynamic SQL Operations 7-2

Developing a Dynamic SQL Application 7-2

Writing a Dynamic SQL Pathway Server 7-3

Specifying Input Parameters and Output Variables 7-4

Using the SQLDA and Names Buffer 7-5

Using Dynamic SQL Programming Techniques 7-7

Overview of a Dynamic SQL Program 7-7

Dynamically Allocating Memory 7-14

Using the Names Buffer 7-23

Allocating and Filling in Output Variables 7-27

Using Dynamic Cursors 7-31

Using Statement and Cursor Host Variables 7-33

Handling Null Values 7-36

A. Sample NonStop SQL Database

B. Examples of Static NonStop SQL Programs

Insertion Program B-1

Date-Time Program B-10

C. Examples of Dynamic NonStop SQL Programs

Dynamic SQL Program C-1

Detailed Dynamic SQL Program C-9

D. NonStop SQL Version Issues

Version 1 and Version 2 Definitions D-1

Summary of Incompatible Changes D-3

Migrating a C10 Program to Run on a C30 System

D-4

Migrating a C10 Program to Access Version 2 Objects

D-7

Dynamic SQL Operations D-7

Static SQL Operations D-8

Catalog Tables D-8

Summary D-8

Installing Migrated Programs D-8

SQL Component Compatibility D-9

Developing C10 Programs with C30 Software D-10

Binding C10 and C30 Object Files D-10

Mixed-Version Programmatic Features D-11

Release Specification Options D-11