Use parameterized commands and avoid dynamic SQL statements.
使用参数化命令，避免动态sql语句。
Setting re-optimization (REOPT) level for dynamic SQL statements.
为动态sql语句设置重新优化(REOPT)级别。
Dynamic SQL statements automatically use these updated statistics.
动态sql语句自动使用这些更新的统计数据。
The default NULLID package set is used to execute dynamic SQL statements.
这时使用默认的NULLID包集来执行动态sql语句。
For dynamic SQL statements, authorization takes place on a per statement basis.
对于动态sql语句，授权针对每个语句进行。
Package Cache - Memory allocated to store both static and dynamic SQL statements.
包缓存——为存储静态和动态sql语句而分配的内存。
For dynamic SQL statements, the SQL path is the value of the CURRENT path special register.
对于动态sql语句，SQL路径为CURRENTPATH特殊寄存器的值。
The output of that process is a pdqxml file that contains the successfully executed dynamic SQL statements.
该过程的输出是一个pdqxml文件，其中包含成功执行的动态SQL元素。
Set the special register CURRENT EXPLAIN SNAPSHOT to YES to capture the snapshot for dynamic SQL statements.
将专用寄存器CURRENTEXPLAINSNAPSHOT 设置为YES以捕获动态SQL语句的快照。
However, most applications use prepared statements rather than dynamic SQL statements, so I won't delve into this.
但是，多数应用程序使用预备语句而不是动态sql语句，所以我不想深入这一部分。
It also provides the default value to the CURRENT FEDERATED ASYNCHRONY special register for dynamic SQL statements.
它还将该缺省值提供给用于动态sql语句的CURRENTFEDERATEDASYNCHRONY专用寄存器。
The package cache sets the amount of database global memory to be used for caching a package's static and dynamic SQL statements.
包缓存器设置数据库全局内存的总量以用于缓存程序包的静态和动态sql语句。
Check that the cache size is sufficiently large and that the cache hit ratio is high for each of the dynamic SQL statements being executed.
对于每个被执行的动态sql语句，请检查高速缓存是否足够大且高速缓存的命中率是否较高。
The technology of dynamic SQL is researched and three methods for using dynamic SQL statements in an embedded SQL system are implemented.
对动态sql技术进行了研究，实现了一个嵌入式SQL系统中动态sql语句处理的3种方法。
However, many packaged applications use dynamic SQL statements with parameter markers and therefore the values of these parameter markers are not known.
但是许多打包的应用程序使用具有参数标记的动态sql语句，因此，这些参数标记的值是未知的。
All data, including dynamic SQL statements, user input data, user output data, and character fields in the SQLCA, is interpreted based on this code page.
所有数据，包括动态sql语句、用户输入数据、用户输出数据以及SQLCA中的字符字段，都是基于该代码页进行解释的。
Use the FLUSH package command to remove all cached dynamic SQL statements currently in the package cache and force the next request to be implicitly compiled.
使用FLUSHPACKAGE命令来删除包缓存器中当前所有缓存的动态sql语句，并强制隐式地编译下一请求。
If the stored procedure does not include any OUT parameters, it can also be invoked using CALL in a tool that executes dynamic SQL statements, such as the ij tool.
如果存储过程不包含任何OUT参数，那么还可以在执行动态sql语句的工具(例如ij工具)中使用CALL来调用它。
The CURRENT SCHEMA special register contains the default qualifier to be used for unqualified objects referenced for dynamic SQL statements issued from within a specific DB2 connection.
特殊寄存器CURRENTSCHEMA包含默认的限定符，用于对特定DB 2连接中发出的动态sql语句所引用的未限定对象进行限定。
SQL statement distribution shows the distribution of dynamic and static SQL statements for a database.
SQL语句分布图显示数据库的动态和静态 SQL语句的分布情况。
Federated procedures with access level MODIFIES SQL DATA cannot be invoked inside triggers, dynamic compound statements, scalar, table, row functions, and methods.
在触发器、动态合成语句、标量、表、行函数和方法中不能调用具有访问级别MODIFIESSQLDATA的联邦过程。
This unique feature makes it possible for dynamic execution of SQL statements at design time with rollback capabilities.
这个独特的特性使得在设计时能够动态执行sql语句并允许回滚。
IF it has MODIFIES SQL DATA, it is blocked in triggers, dynamic compound statements, SQL-bodied functions, or when a save point has been created, and error SQL30090 with reason code 22 is returned.
如果访问级别是MODIFIESSQLDATA，那么它在触发器、动态合成语句、sql体函数中或在创建保存点时会阻塞，并返回原因码为22的错误SQL 30090。
However, JDBC provides finer-grained control over the execution of SQL statements and offers true dynamic SQL capability.
然而，JDBC提供了对sql语句的执行的细粒度控制，并提供了真正的动态sql能力。
From dynamic SQL snapshot data as the initial step based on the counters in Listing 6, you should be able to list out the top SQL statements in terms of total cost, frequency, and cost per invocation.
在清单6中，从根据计数器作为初始步骤的动态sql快照数据中，您可以从总体成本、频率和每次调用成本角度列出最优sql语句。
Add to this the fact that these SQL statements are dynamic, and it becomes even more difficult to track down the originating code that produced the SQL.
除此之外，这些sql语句还是动态的，很难找到生成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语句的静态部分和动态部分构造数据库调用。
However, typical applications that use Hibernate (or OpenJPA) would use SQL statements with input parameters due to the dynamic nature of the applications.
不过，使用Hibernate(或openjpa)的典型应用程序出于动态性会使用带输入参数的sql语句。
Recent SQL statements (from the dynamic SQL snapshot).
最近的sql语句(来自动态sql快照)。
Recent SQL statements (from the dynamic SQL snapshot).
最近的sql语句(来自动态sql快照)。
应用推荐