Using host variables in a static SQL program would have a similar benefit.
在静态SQL程序中使用主机变量也可以获得类似的好处。
PDA decides whether the strings can be sent as host variables or parameter markers.
PDA决定将这些字符串以主机变量还是参数标记符的形式发送。
ODBC applications do not require the explicit declaration and use of host variables.
ODBC应用程序不需要显式声明，也不需要使用宿主变量。
For a Unicode database, you should use host variables instead of using string constants.
对于Unicode数据库，您应使用主机变量来代替字符串常量。
The REOPT bind option affects the optimization of statements that contain parameter markers or host variables.
REOPT绑定选项将影响其中包含参数标记或主机变量的语句的优化。
High: This tracing level captures all of the information included in medium - level tracing, plus host variables.
High：此跟踪级别捕捉中级跟踪涉及的所有信息，再加上主机变量。
In addition, the application encoding bind option can also define the CCSID for the host variables in the program.
此外，应用程序编码绑定(bind)选项也可以为程序中的主机变量定义CCSID。
This provider now supports host variables, modules, the ARRAY data type, compound statements, and variable length timestamps.
目前这个提供程序支持主机变量、模块、ARRAY数据类型、复合语句和可变长度时间戳。
In some cases, the access path does not perform well at runtime if the statement contains host variables, parameter markers, or special registers.
某些情况下，如果语句包含主机变量、参数标记或特殊寄存器那么访问路径在运行时的性能不会很好。
You have also examined how the use of parameter markers/host variables may limit the consideration of distribution statistics by the DB2 optimizer.
您还研究了参数标记/主变量的使用会为DB2优化器对分布统计信息的考虑带来怎样的限制。
For example, the optimizer does not know the values of host variables or parameter markers (if these are contained in the query) until the query is executed.
例如，优化器到执行时才会知道主机变量或参数标记的值(如果查询中包含的话)。
This can occur if the IN list contains parameter markers or host variables which prevent the optimizer from using catalog statistics to determine the selectivity.
如果IN列表中包含参数标记符或主机变量，使优化器不能使用编目统计信息来确定选择性，就会出现这种情况。
As we've discussed in this article, the DB2 optimizer may choose a sub-optimal access plan when there are host variables or parameter markers in the SQL statement.
正如我们在本文讨论的，如果sql语句中存在主机变量或参数标记，那么DB 2优化器可能会选择一个次优化的存取计划。
Taking into account any host variables and parameters used, to preview result sets, and to auto-rollback any side effects that the execution of SQL statements may cause.
运行sql语句时，将考虑所使用的全部主机变量和参数，以预览结果集，并自动回滚执行sql语句导致的副作用。
Try out the examples in this article to experience how you can improve runtime performance for queries that contain host variables or parameter markers by using the REOPT option.
通过尝试本文所给出的示例，您就能够体验到如何使用REOPT选项来提高那些包含主机变量或参数标记的查询的运行时性能。
Try out the examples in this article to experience how you can improve runtime performance for queries that contain host variables or parameter markers by using the REOPT option.
通过尝试本文所给出的示例，您就能够体验到如何使用REOPT选项来提高那些包含主机变量或参数标记的查询的运行时性能。
应用推荐