SQL/MP Installation and Management Guide

Managing Database Applications
HP NonStop SQL/MP Installation and Management Guide—523353-004
10-14
CONTROL QUERY BIND NAMES Directive
The sample database described in the SQL/MP Reference Manual includes a sample
program that uses execution-time name resolution. For sample scenarios of use, see
Using DEFINEs on page 10-30.
CONTROL QUERY BIND NAMES Directive
Execution-time name resolution is requested by using the CONTROL QUERY BIND
NAMES directive. This directive is used at the statement level in SQL programs and,
as such, is not accessible at a system management level. Using this option, however,
might be appropriate for your application. For more information about the CONTROL
QUERY BIND NAMES directive, see the SQL/MP programming manual for your host
language.
Avoiding Automatic SQL Recompilations
To prevent unnecessary automatic SQL recompilations of a program or SQL
statement, use the similarity check with execution-time name resolution. You use DDL
statements to enable the similarity check for each table or protection view referenced
in the statement. (SQL implicitly enables the similarity check for other SQL objects.) To
enable the similarity check for an SQL program, compile the program by using the
CHECK INOPERABLE PLANS option. For more information, see Using Similarity
Checks on page 10-15.
Figure 10-1. Name Resolution For SQL Statements
SQL Load Time
Run-Time Environment
Execution-Time Name Resolution
...
VST007.vsd
SQL Statement-1
Execution Time
Execution Plan-1
name-1,
name-2,
...
name-n
Execution Plan-2
name-1,
name-2,
...
name-n
Execution Plan-n
name-1,
name-2,
...
name-n
2 3
SQL
Program
File
Explicit SQL
Compilation
1
SQLCOMP
Process
SQL Statement-2
Execution Time
SQL Statement-n
Execution Time