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应用程序。
For static SQL statements, the SQL path is specified using the FUNCPATH bind option.
对于静态sql语句,使用FUNCPATH绑定选项指定SQL路径。
SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
Static SQL statements are qualified with the authorization ID of the person binding the application (by default).
静态sql语句(在默认情况下)由绑定应用程序的用户的授权ID进行限定。
SQLJ provides the unique ability to develop using static SQL statements and control access at the DB2 package level.
SQLJ提供了独特的使用静态SQL语句进行开发以及在DB2包级别控制访问的能力。
If your applications execute static SQL statements, then the SQL activity reports show them as well, together with the summary or operational information.
若应用程序执行静态sql语句,则SQL活动报告同样显示它们,以及摘要或操作信息。
Hence, objects and packages containing static SQL statements can become invalidated when the privileges of the object creator or binder of the package are revoked.
因此,当对象创建者或包的绑定者的特权被撤销时,包含静态sql语句的对象和包将失效。
If static SQL is executed in your monitored database and you want to collect the data into the report, check the check box Retrieve the text of static SQL statements.
如果在数据库中执行静态SQL,希望把它们的数据收集到报告中,那么选中复选框Retrieve thetextofstatic SQL statements。
Next, bind SQL statements into a DB2 package and execute the application using static SQL, as shown in Figure 19.
下面,将一些sql语句绑定到一个DB 2包中并使用静态SQL执行应用程序,如图19所示。
You then turned SQL statements using literals into parameterized SQL so the code could be executed using static execution mode.
然后您将使用文本的SQL语句转换为参数化的 SQL,以便代码可以使用静态执行模式执行。
When the application is executed, the capture file contains all the SQL statements that could potentially be switched to static SQL.
当执行应用程序时,捕获文件包含可能被潜在地转换为静态SQL的所有sql语句。
The package cache sets the amount of database global memory to be used for caching a package's static and dynamic SQL statements.
包缓存器设置数据库全局内存的总量以用于缓存程序包的静态和动态sql语句。
At this point, you should have successfully bound to the database the SQL statements that were missing during the generation time using static generator.
此时,您应该已经将使用静态生成器生成时遗漏的sql语句成功绑定到数据库。
With static SQL, users only receive privileges to execute the output of the bind process, known as the package, and that package contains the SQL statements.
使用静态SQL,用户仅收到执行绑定进程输出(称为包)的权限,并且该包包含sql语句。
REBIND packages containing static SQL using the bind command, or the REBIND command (and optionally re-explain their statements) after collecting statistics with RUNSTATS.
在用RUNSTATS收集了统计信息之后,要使用BIND命令或REBIND命令重新绑定包含了静态SQL的包(并可以选择重新解释其语句)。
In this case, the clause is parsed at runtime, and the call against the database is built up from the static and dynamic parts of the Open SQL statements.
在这种情况下,在运行时解析子句,根据Opensql语句的静态部分和动态部分构造数据库调用。
The JPA utility used to collect SQL statements is called the static generator and is invoked using wsdb2gen in your % WAS_HOME % \ bin directory, as shown in Figure 3.
用于收集sql语句的jpa实用工具称为静态生成器,并使用% WAS_HOME % \bin目录中的wsdb2gen进行调用,如图3所示。
Package Cache - Memory allocated to store both static and dynamic SQL statements.
包缓存——为存储静态和动态sql语句而分配的内存。
Package Cache - Memory allocated to store both static and dynamic SQL statements.
包缓存——为存储静态和动态sql语句而分配的内存。
应用推荐