SQL Programming Manual for TAL

Contents

HP NonStop SQL Programming Manual for TAL—527887-001

D. NonStop SQL Version Issues (continued)

System Procedures D-11

Techniques for Mixed-Version Programming D-12

Handling Mixed-Version-Objects D-12

Running on Multiple NonStop SQL Releases D-13

Using the Single-Code Thread Design D-14

E. Enforcing Data Integrity

Using Constraints E-1

Managing Referential Integrity E-2

Index

Figures

Figure i. Related Manuals xiv

Figure 1-1. Static SQL Statements in a TAL Program 1-5

Figure 1-2. Dynamic SQL Statements in a TAL Program 1-6

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

Figure 4-1. SQLSADISPLAY Display 4-24

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

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

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

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. Checking the SQLCODE Variable 6-3

Figure 6-2.

Enabling and Disabling the WHENEVER Directive 6-6

Figure 6-3.

Using WHENEVER Directives 6-8

Figure 6-4. Calling an SQL System Procedure 6-10

Figure 6-5. SQLSA Structure Description 6-11

Figure 6-6. Release C30 SQLDA Template and Names Buffer 6-15

Figure 6-7. Release C10 SQLDA Template and Names Buffer 6-16

Figure 6-8. SQLDA Structure Template 6-22

Figure 7-1. Using a PREPARE Statement to Compile a Statement 7-16

Figure 7-2. Allocating the SQLDA Structure 7-19

Figure 7-3. Allocating Memory for Values 7-22

Figure 7-4. Getting Parameter Values 7-25

Figure 7-5. Displaying Output 7-29

Figure 7-6. Statement and Cursor Host Variables 7-34