SQL/MP Programming Manual for C

Explicit Program Compilation
HP NonStop SQL/MP Programming Manual for C—429847-008
6-24
SQL Program File Format

Insufficient information. The SQL compiler does not have enough information to
determine the validity of a statement. For example, an unavailable table might not
exist, or it might reside on an unavailable remote node. (This situation 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 references a nonexistent DEFINE.
SQL Program File Format
The input program file to the SQL compiler can be a C object file, a file generated by
the Binder program, a file generated by the Accelerator, the OCA, or a file previously
compiled by the SQL compiler. Figure 6-4 shows the format of an SQL program file.
Figure 6-4. SQL/MP Program File Format
Accelerated Object Code
TNS/R (AXCEL) or TNS/E
(OCA)
File Label
Information
Generated by the
SQL Compiler
C Object Code
Execution Plans
Generated by the
SQL Compiler
Including
Stored DEFINEs
SQL Source Statement
n
SQL Source
Statements
Stored by the
C Compiler
SQL Program File
SQL Valid Flag
SQL Object Code
•
•
•
Compilation Timestamp
SQL Sensitive Flag
VST004.vsd
Accelerated Object Code
for TNS/R (AXCEL)
or TNS/E (OCA)
Accelerated
Object Code
Object Code
Generated by
the C Compiler
SQL Source Statement 1
SQL Source Statement 2