SQL Programming Manual for Pascal

Contents
HP NonStop SQL Programming Manual for Pascal—528614-001
iv
5. Program Compilation and Execution
5. Program Compilation and Execution
Compiling a Pascal Program 5-2
Running the Pascal Compiler 5-3
Using Binder 5-4
Running the Accelerator 5-5
Running the SQL Compiler 5-6
Using the EXPLAIN Utility 5-17
Generating an EXPLAIN DEFINES Report 5-19
Determining Program File Validity 5-21
SQL Sensitive Program Files 5-22
SQL Valid Program Files 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
Run-Time Recompilation Errors 5-27
Maximizing Local Autonomy 5-28
Using a Local Partition 5-28
Using DEFINEs 5-29
Using Current Statistics 5-29
Skipping Unavailable Partitions 5-29
Executing an SQL Program File 5-29
Using the RUN Command 5-30
Guidelines for Using DEFINEs 5-31
Estimating Memory Use 5-32
6. Error and Status Processing
Getting Error and Warning Information 6-1
Checking the SQLCODE Variable 6-1
Using the WHENEVER Directive 6-3
Getting Information From the SQLCA 6-8
Getting Execution Statistics 6-9
SQL Statements’ Effect on the SQLSA 6-9
Declaring the SQLSA 6-10
Using the SQLSA 6-10
Getting Information About Dynamic SQL Operations 6-13
Declaring the SQLDA and Names Buffer 6-14