SQL Programming Manual for Pascal

HP NonStop SQL Programming Manual for Pascal—528614-001
5-1
5
Program Compilation and Execution
This section describes the compilation and execution of a Pascal program that
contains embedded SQL statements:
•
Compiling a Pascal source program including running the Pascal and SQL
compilers and using the Binder program
•
Using the EXPLAIN utility
•
Determining SQL program file validity
•
Understanding automatic SQL recompilation
•
Maximizing local autonomy
•
Executing an SQL program file
•
Estimating memory use
Figure 5-1 on page 5-2 shows the steps you follow to compile and execute a Pascal
program that contains embedded SQL statements. Steps 1 through 4 are described
under Compiling a Pascal Program on page 5-2. These steps are similar to the steps
for a Pascal program that does not contain embedded SQL statements, except for the
SQL compilation step (Step 3). Step 5 is described under Executing an SQL Program
File on page 5-29.