Decide on dynamic vs. static SQL.
动态或静态SQL选择。
Run the application using static SQL.
使用静态SQL运行应用程序。
Static SQL support for stored procedures.
针对存储过程的静态SQL支持。
什么是静态SQL？
Prepare the application to run using static SQL.
使用静态SQL准备将要运行的应用程序。
Your workload consists of substantial static SQL.
工作负载主要由静态SQL组成。
Using static SQL and heterogeneous batch together.
同时使用静态SQL和异构批处理特性。
What is static SQL and how can it help performance?
何为静态SQL且它如何有助于性能提升？
Static SQL statements (from application packages).
静态sql语句(来自应用程序包)。
Specifying the REOPT option for static SQL statements.
指定静态sql语句的REOPT选项。
Using Static SQL and heterogeneous batch together.
联合使用静态SQL和异构批处理。
For SQLJ applications with embedded static SQL statements.
对于含嵌入式静态sql语句的SQLJ应用程序。
In such cases, static SQL cannot be applied to those queries.
在这种情况下，不能对这些查询应用静态SQL。
From design to bind: Improved tools for static SQL development.
从设计到绑定：改进的静态SQL开发工具。
Collaborate effectively with the DBA for static SQL development.
与dba有效地合作进行静态SQL开发。
For more information on static SQL, refer to the Resources section.
有关静态SQL的更多信息，请参阅参考资料部分。
The security model for static SQL is also different than for dynamic SQL.
静态SQL与动态sql的安全模型也不同。
Using host variables in a static SQL program would have a similar benefit.
在静态SQL程序中使用主机变量也可以获得类似的好处。
The rules in this case are similar to the way static SQL is written in ABAP.
这些规则与用abap编写静态SQL的规则相似。
The security model for static SQL is also different from that of dynamic SQL.
静态SQL与动态sql的安全模型也不同。
Also, analyzing all the static SQL in a package is easier done with db2expln.
同样，使用db 2 expln更容易分析一个包中所有的静态SQL。
Easily improve your application performance with static SQL and no extra work.
用静态SQL轻松地提高应用程序性能，不需要做额外工作。
Figure 2 shows a comparison between the execution of dynamic SQL and static SQL.
图2显示了动态sql执行与静态SQL执行的对比。
The static SQL statement is pre-compiled and bound to a package before execution.
静态SQL语句是在执行之前预编译并绑定到一个包上的。
Run the sample application in static SQL execution mode, and validate its correct behavior.
以静态SQL执行模式运行示例应用程序，并验证它是否具有正确的行为。
For more information about the performance and security benefits of static SQL, see Resources.
要了解更多关于静态SQL在性能和安全性方面的优点，请参阅参考资料。
Static SQL provides both performance and security benefits for applications that access DB2.
静态SQL为访问DB2的应用程序同时提供性能和安全优势。
Static SQL in DB2 is a powerful capability that enables you to streamline data access at runtime.
DB2中的静态SQL是一个强大的功能，能使您在运行时精简数据访问。
SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
In static SQL, this is not an issue, because the expected data types are known during programming time.
对于静态SQL，这不是问题，因为在编程时知道预期的数据类型。
应用推荐