该参数控制由连接池缓存的最大预编译语句数。
This parameter controls the maximum number of prepared statements cached by a connection pool.
预编译语句的自动重新编译。
当执行预编译语句时,IDS检测底层对象的变化,必要时重新准备(重新编译)语句。
When you execute a prepared statement, IDS now detects changes to underlying objects and re-prepares (re-compiles) the statement if needed.
在预编译和绑定时,代码页派生于用于预编译语句和SQLCA中返回的所有字符数据的数据库连接。
At precompile and bind time, the code page derived at the database connection is used for precompiled statements, and any character data returned in the SQLCA.
我们在上面的代码中使用了一个预编译语句,以使得能够更容易地在查询中填充相关的数据。
We've used a prepared statement in the above to make the process of filling in the data much easier within the query.
我们本可以使用一个预编译语句并且每次重新设置数据,但是为了保持完整性,我们决定在每次循环的时候重新创建它。
We could have used a prepared statement and just reset the data each time, but we decided to recreate it for each iteration of the loop here for completeness.
静态SQL语句是在执行之前预编译并绑定到一个包上的。
The static SQL statement is pre-compiled and bound to a package before execution.
预备语句允许您用一条常用的sql语句然后预编译它,从而在这条语句被多次执行的情况下大幅度地提升性能。
A prepared statement allows you to take a commonly used SQL statement and pre-compile it, thereby dramatically improving performance if the statement is executed multiple times.
本文主要讨论GKD -ESQL预编译器的设计和实现技术,首先讨论了嵌入式SQL语言的基本结构和语句成分,在此基础上,给出了GKD - ESQL系统的总体框架设计。
The design and implementation of GKD-ESQL is discussed. Based on the introduced basic structure and the statement elements, the general infrastructure of GKD-ESQL system is presented.
它代表的是一个预编译的SQL语句的实例。
存储过程是sql语句和可选控制流语句的预编译集合,以一个名称存储并作为一个单元处理。
Stored procedures are a precompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit.
存储过程是sql语句和可选控制流语句的预编译集合,以一个名称存储并作为一个单元处理。
Stored procedures are a precompiled collection of SQL statements and optional control-of-flow statements stored under a name and processed as a unit.
应用推荐