Decide on dynamic vs. static SQL.
动态或静态SQL选择。
Run the application using static SQL.
使用静态SQL运行应用程序。
什么是静态SQL?
Static SQL support for stored procedures.
针对存储过程的静态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和异构批处理特性。
Using Static SQL and heterogeneous batch together.
联合使用静态SQL和异构批处理。
Static SQL statements (from application packages).
静态sql语句(来自应用程序包)。
Specifying the REOPT option for static SQL statements.
指定静态sql语句的REOPT选项。
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开发。
Authorization for static SQL takes place at compile or bind time.
对静态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的安全模型也不同。
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语句是在执行之前预编译并绑定到一个包上的。
For static SQL statements, the SQL path is specified using the FUNCPATH bind option.
对于静态sql语句,使用FUNCPATH绑定选项指定SQL路径。
Run the sample application in static SQL execution mode, and validate its correct behavior.
以静态SQL执行模式运行示例应用程序,并验证它是否具有正确的行为。
Static SQL provides both performance and security benefits for applications that access DB2.
静态SQL为访问DB2的应用程序同时提供性能和安全优势。
For more information about the performance and security benefits of static SQL, see Resources.
要了解更多关于静态SQL在性能和安全性方面的优点,请参阅参考资料。
In order to enable static SQL, you need to work around this issue in one of the following ways.
为了启用静态SQL,您需要通过以下方式解决该问题。
For example, suppose the following static SQL statement is found in an embedded-SQL application.
例如,假设在一个嵌入式SQL应用程序中有以下的静态sql语句。
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语句的分布情况。
应用推荐