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语句而分配的内存。
Use parameterized commands and avoid dynamic SQL statements.
使用参数化命令,避免动态sql语句。
For dynamic SQL statements, the SQL path is the value of the CURRENT path special register.
对于动态sql语句,SQL路径为CURRENTPATH特殊寄存器的值。
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语句,所以我不想深入这一部分。
The package cache sets the amount of database global memory to be used for caching a package's static and dynamic SQL statements.
包缓存器设置数据库全局内存的总量以用于缓存程序包的静态和动态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种方法。
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语句,请检查高速缓存是否足够大且高速缓存的命中率是否较高。
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语句所引用的未限定对象进行限定。
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语句所引用的未限定对象进行限定。
应用推荐