SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-27
Run-Time Recompilation Errors
Run-Time Recompilation Errors
For automatic SQL recompilation of an entire program at run time, the SQL executor
returns compilation errors or warnings as follows:
•
If an SQL statement causes an error or warning, the statement remains
uncompiled in the program file and the SQL executor suppresses the error or
warning message.
Figure 5-7. Run-Time Checks and Automatic SQL Recompilation
CPU
SQL Executor
SQL Object Code
(copy)
. . .
SELECT . . .
FROM TABLEA . . .
Timestamp PROGRAMA
VST0507.vsd
Catalog
Timestamp TABLEA
Catalog
FROM TABLEA . . .
SELECT . . .
SQL Object Code
. . .
Timestamp PROGRAMA
Object
Automatic SQL
Recompilation
Rewrites Area