SQL Programming Manual for TAL

Contents

HP NonStop SQL Programming Manual for TAL—527887-001

iii

5. Program Compilation and Execution

Compiling a TAL Program 5-2

Running the TAL Compiler 5-3

Using the Binder Program 5-4

Including the TALLIB Run-Time Library 5-4

Running the Accelerator 5-5

Running the SQL Compiler 5-5

Using the EXPLAIN Utility 5-17

Determining Program File Validity 5-22

Changes to a Program File 5-22

Changes to Database Objects 5-23

Other Changes 5-23

Understanding Automatic SQL Recompilation 5-24

Predicting Automatic SQL Recompilation 5-24

Understanding the Run-Time Timestamp Check 5-26

Understanding Run-Time Recompilation Errors 5-28

Maximizing Local Autonomy 5-28

Using a Local Partition 5-28

Using TACL DEFINEs 5-29

Using Current Statistics 5-29

Skipping Unavailable Partitions 5-30

Executing an SQL Program File 5-30

Using the RUN Command 5-30

Using TACL DEFINEs 5-31

Estimating Program Size 5-32

6. Error and Status Processing

Getting Error and Warning Information 6-1

Using the SQLCODE Variable 6-1

Using the WHENEVER Directive 6-4

Getting Information From the SQLCA 6-9

Getting Performance and Statistics Information 6-10

Getting Information About Dynamic SQL Operations 6-13

Declaring the SQLDA and Names Buffer 6-14

Initializing the EYE^CATCHER Field 6-18

Using Literal Declarations for the SQLDA 6-18

Example of Using the SQLDA 6-21