SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-16
Running the SQL Compiler
•
Insufficient information
The SQL compiler did not have enough information to determine the validity of a
statement. For example, an SQL statement refers to a table that is unavailable
because the table is on an unavailable remote node. (Another example is an SQL
statement that refers to a table that does not exist. This case always occurs for a
program that both creates and refers to a table; the table, of course, does not exist
when the program is explicitly SQL compiled.)
•
Unresolved DEFINEs
An SQL statement often uses a DEFINE name that is not present in the DEFINE
set when the program is explicitly SQL compiled.
SQL Compiler Listings
The SQL compiler writes all the SQL statements in the program file to a listing. If error
or warning conditions occur, the compiler writes messages following the statements
that cause the condition.
For SQL DML statements, the SQL compiler includes the estimated cost of processing
the statement in the listing following the statement. This estimate is a positive integer
that indicates the relative cost. For example, the larger the value, the more CPU time
and disk access time is required to execute the statement.
Figure 5-3 on page 5-17 shows a sample SQL compiler listing.