Generating dynamic SQL statement.
生成动态sql语句。
First, we will compose a dynamic SQL statement with five parameter markers.
首先，需要构造一个具有5个参数标记的动态sql语句。
For dynamic SQL statements, authorization takes place on a per statement basis.
对于动态sql语句，授权针对每个语句进行。
I may have the same dynamic SQL statement in each interval, if it ran multiple times.
如果一个动态sql语句运行了多次，我可能在每个时间段内拥有相同的动态sql语句。
This is in contrast to a dynamic SQL statement, whose syntax is not known until run-time.
反之就是动态sql语句，其语法直到运行时才知道。
JDBC offers two possibilities to execute a dynamic SQL statement and, therefore, provides two different interfaces.
JDBC提供了两种途径来执行动态sql，因而也提供了两种不同的接口。
From the performance perspective, dynamic SQL statement can be prepared once and executed multiple times, reusing the same database access plan.
从性能的角度来看，动态sql语句只需要准备一次就可以执行多次，可以重用相同的数据库访问计划。
In order for a PERL program to transform a dynamic SQL statement into executable form, you need to first use the prepare method, and then bind parameters using the bind_param method.
为了让Perl程序将动态sql语句转换成可执行的格式，需要首先使用prepare方法，然后使用bind _ param方法来绑定参数。
Now let's see how to execute an SQL statement which is unknown at the time the application is written and has parameter markers or placeholders; that is, a truly dynamic SQL statement.
现在让我们来看一下如何执行在编写应用程序时还不确定并且具有参数标记（即占位符）的SQL语句 ——即真正的动态 SQL 语句。
SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
Finally, in the improved example, you can see that the SQL statement and output do not include a dynamic column selection.
最后，在改进的示例中，您可以看到该sql语句和输出没有包括动态列选项。
Varying-list dynamic SQL is typically used when an application builds the entire SQL statement from scratch.
当应用程序从头开始构建整个SQL语句时，通常会用到变动列表动态 SQL。
Each JDBC call is dynamic in nature and requires the SQL statement to be parsed and optimized at run time.
每个jdbc调用在性质上是动态的，要求在运行时分析和优化sql语句。
Additional privileges may be required on individual objects being referenced by the stored procedure, depending on the bind options and whether the SQL statement is static or dynamic.
根据绑定选项和sql语句是静态还是动态，存储过程引用到的各对象可能需要更多的特权。
For this article, I will be using a combination of fixed-list dynamic SQL and static embedded SQL (for the UPDATE statement) to create a format-based handler.
对于本文，我将结合使用固定列表动态sql和静态嵌入式SQL(用于update语句)来创建一个基于格式的Handlder程序。
DB2 9.7 introduces the statement concentrator feature that improves the performance of programs that use dynamic SQL, and are developed in languages such as Ruby and PHP.
DB 2 9.7引入了语句集中器特性，提高了使用动态sql以及Ruby和php语言开发的程序的性能。
After we compose our SQL statement, all the other steps are the same as for any dynamic statement with parameter markers.
在构造sql语句之后，剩下的步骤就与其他具有参数标记的动态语句完全相同了。
For further flexibility, dynamic SQL allows for changing this option within a plan or package by the SET CURRENT DEGREE statement, which controls the value in a special register.
为获得更大的灵活性，动态SQL允许通过SETCURRENTdegree语句在一个计划或包中更改这个选项，该语句可以控制专用寄存器中的值。
With DB2 9 and dynamic SQL, REOPT ALWAYS can also be specified through a global - or statement-level optimization profile.
对于DB 29和动态sql，也可以通过一个全局或语句级别的优化配置来指定REOPT ALWAYS。
In this example, the SQL statement is a dynamic statement that would allow the same attack.
在本例中，sql语句是允许相同攻击的动态语句。
The statement-based handler is better suited for varying-list style dynamic SQL.
基于语句的 Handler程序更适合变动列表样式的动态 SQL。
The statement-based handler is better suited for varying-list style dynamic SQL.
基于语句的 Handler程序更适合变动列表样式的动态 SQL。
应用推荐