SQL Programming Manual for Pascal
Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-21
Determining Program File Validity
Determining Program File Validity
SQL program files can be valid or invalid. A valid program file can execute with the
current description of the database. Certain operations performed on the program file
Figure 5-6. EXPLAIN Utility Report
VST0506.vsd
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
DEFINES MAPPING
ALTER DEFINE =_DEFAULTS, VOLUME \SYS1.$VOL1.PROGS
ALTER DEFINE =_DEFAULTS, CATALOG \SYS1.$VOL1.INVENT
ADD DEFINE =EMPLOYEE, FILE \SYS1.$VOL1.PERSNL.EMPLOYEE
ADD DEFINE =CUSTOMER, FILE \SYS1.$VOL1.SALES.CUSTOMER
ADD DEFINE =ORDERS, FILE \SYS1.$VOL1.SALES.ORDERS
. . .
109
CONTROL EXECUTOR PARALLEL EXECUTION ON
Options : NOFORCE, NOOBJECT, STOREDDEFINES, RECOMPILE,
RECOMPILEALL, EXPLAIN PLAN DEFINES, OBEYFORM
SQL Compiler - T9095C30 - (15AUG89)
COPYRIGHT TANDEM COMPUTERS INCORPORATED 1987, 1988, 1989
DATE - TIME : 09/24/89 - 09:18:15
*************************************************************
SQL - PROGRAM FILE = \SYS1.$VOL1.PROGS.OXPLAIN
SQL - PROGRAM CATALOG = \SYS1.$VOL1.INVENT
SQL - DEFAULT CATALOG = \SYS1.$VOL1.INVENT
SQL - Source File = \SYS1.$VOL1.PROGS.XPLAIN
DECLARE GET_EMP_BY_AVG_SAL_CURSOR CURSOR FOR
59
SELECT EMPNUM, FIRST_NAME, LAST_NAME, SALARY
60
FROM =EMPLOYEE
61
WHERE SALARY >
62
( SELECT AVG (SALARY)
63
FROM =EMPLOYEE
64
BROWSE ACCESS )
65
AND DEPTNUM = :select_dept
66
BROWSE ACCESS
67
68
-----------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
QUERY PLAN : 1
STATEMENT TYPE : SELECT
- Summary of SQL Compiling
- Number of SQL Statements = 3
- Number of SQL Errors = 0
- Number of SQL Warnings = 0
- Number of other Errors = 0
- Compile Time = 00:00:01.887
- Elapsed Time = 00:00:11.656
- Program file is \SYS1.$VOL1.PROGS.OXPLAIN
- >> PROGRAM FILE UNCHANGED BECAUSE OF NOOBJECT OPTION <<
*************************************************************
*************************************************************
SQL
SQL
SQL
SQL
SQL
SQL
SQL
SQL
SQL
SQL
SQL