SQL Programming Manual for Pascal

Contents

HP NonStop SQL Programming Manual for Pascal—528614-001

D. NonStop SQL Version Issues (continued)

Developing C10 Applications with C30 Software D-10

Binding C10 and C30 Object Files D-10

Programmatic Features for Version Control D-11

Release Specification Options D-11

Version Information Procedures D-11

Programming Techniques for Mixed Versions D-12

Generic Release Programs D-12

Using the Single-Code Thread Design D-14

E. Enforcing Data Integrity

Using Constraints E-1

Managing Referential Integrity E-2

Examples E-2

Index

Figures

Figure i. Related Manuals xiii

Figure 1-1. Static SQL Statements in a Pascal Program 1-4

Figure 1-2. Dynamic SQL Statement in a Pascal Program 1-5

Figure 1-3. Compiling and Executing a Program 1-6

Figure 4-1. SQLSADISPLAY Display Format 4-24

Figure 5-1. Compiling and Executing a Program 5-2

Figure 5-2. NonStop SQL Program File Format 5-13

Figure 5-3. Sample SQL Compiler Listing 5-17

Figure 5-4. OBEY command file Format of the EXPLAIN DEFINES Report 5-19

Figure 5-5.

INFO DEFINE Format of the EXPLAIN DEFINES Report 5-20

Figure 5-6.

EXPLAIN Utility Report 5-21

Figure 5-7. Run-Time Checks and Automatic SQL Recompilation 5-27

Figure 6-1. SQLSA Record Description 6-11

Figure 6-2. NonStop SQL Release 2 SQLDA Record Description and Names

Buffer 6-15

Figure 6-3. NonStop SQL Release 1 SQLDA Record Description and Names

Buffer 6-16

Figure 7-1. Sample SQLDA TYPE Declaration 7-17

Figure 7-2. Declaring SQLDA and Names Buffer Pointers 7-18

Figure 7-3. Using PREPARE to Compile a Statement 7-19

Figure 7-4. Preparing to Allocate the SQLDA 7-21

Figure 7-5. Allocating the SQLDA and Names Buffer 7-22