SQL/MX Programming Manual for Java

SQL/MX Programming Considerations
HP NonStop SQL/MX Programming Manual for Java—523726-003
4-3
Causes of Dynamic Execution
The -missingSQLObject Set to False
If -missingSQLObject is false, all referenced database objects must exist at the
time of customization for customization to succeed. If customization succeeds, all the
SQL statements in an SQLJ program run statically in the customized run time.
However, if an SQL statement refers to a database object that does not yet exist,
customization fails. If you execute an SQLJ program that does not have an extended
Figure 4-1. Effect of the -missingSQLObject Option
Yes
No
Yes Yes
No No
Did you try to
customize the profile?
Did you set the
-missingSQLObject
option to true?
Were all
referenced database
objects available at
customization?
Customization
succeeds. All SQL
statements run
statically.
Were all
referenced database
objects available at
customization?
Yes
No
VST005.vsd
Start
All SQL
statements run
dynamically.
Customization
succeeds for SQL
statements that
refer to existing
database objects.
The customized
statements run
statically. The
uncustomized
statements run
dynamically.
Customization
succeeds. All SQL
statements run
statically.
Customization
fails. All SQL
statements run
dynamically.