Combine chains of SET statements into a single VALUES into statement.
将set语句链组合到单个VALUESinto语句中。
For J2EE applications, you can set statement caching on the application server.
对于J2EE应用程序,您可以在应用程序服务器上设置语句缓存。
This is indicated in ESQL SET statement syntax using a colon character to separate the two sections of the Qualified Name.
在ESQLset语句语法中,用冒号分隔限定名(Qualified Name)的两部分,以此来表示这一点。
Use the SET statement to alter existing fields in the logical tree or to create them in circumstances where they do not already exist.
使用set语句来更改逻辑树中现有的字段或者在这些字段不存在的情况下创建它们。
Although different access paths for the same SQL statement produce the same result set, they most likely do not perform the task with the same level of performance.
虽然相同sql语句的不同访问路径会产生相同的结果集,但是它们很有可能不会通过同样的性能级别来执行任务。
He describes how to use class wrapping of the JDBC driver, connection, statement, and result set objects to instrument JDBC, and hence, database calls.
他介绍了如何使用JDBC驱动、连接、语句、结果集对象的类包装来工具化jdbc,并由此工具化数据库调用。
When you set the statement terminator in an SQL script that contains existing statements, the editor does not update the existing statement terminators automatically.
当您在一个已经包含了语句的SQL脚本中设置语句结束符时,编辑器不会自动修改原有的语句结束符。
Personal Mission Statement: Write a personal mission statement, and use it as a guide to set goals.
个人使命宣言:写一份个人使命宣言,并以此作为设定目标的指导。
The parameter object will be used to set input values in an UPDATE statement, or WHERE clause values in a query (etc.).
这个参数对象将用于设置update语句中的输入值,或者用于设置某一查询中的where子句的值(等等)。
But a statement object submits different SQL statements to batch, while prepared statement submits a set of parameters to batch.
但语句对象提交不同的sql语句进行批处理,而预置语句提交的是一组参数。
For further flexibility, dynamic SQL allows for changing this option within a plan or package by the SET CURRENT DEGREE statement, which controls the value in a special register.
为获得更大的灵活性,动态SQL允许通过SETCURRENTdegree语句在一个计划或包中更改这个选项,该语句可以控制专用寄存器中的值。
Since only one row is expected in the result set from this SELECT statement, the table scan here is considered an expensive operation.
因为该select语句的结果集中只期望一行,所以表扫描在这里被认为是代价较高的操作。
The INSERT statement is prepared as usual, and its four parameter markers are set.
insert语句像平常一样准备好了,它的四个参数标志符也设置好了。
Execute the prepared statement obtaining a result set.
执行这个预定义语句获取一个结果集。
The SET EXPLAIN statement now supports an optional parameter to override the default name and location of the output file.
SETexplain语句现在支持一个可选的参数,用于覆盖输出文件的默认名称和位置。
This file is cumulative, in other words, if you have multiple SQL queries after SET EXPLAIN on statement, each query execution plan and its costs would be appended to this file until it is removed.
该文件是累积的,换言之,如果SETEXPLAINON语句之后有多个SQL查询,每个查询的执行计划及其成本都会被追加到文件中,直到将之删除。
The second query evaluated USES an SQL statement that returns thousands of result set rows.
测试的第二个查询使用了一条将返回包含数千行数据的结果集的sql语句。
Additionally, further constraints could also result in the table not being available right after the LOAD operation, requiring you to run the SET INTEGRITY SQL statement first.
此外,进一步的约束还可能导致在LOAD操作之后该表不可用,而要求您首先运行SETINTEGRITYsql语句。
For optimal performance, it is important to have statement caching turned on and set to a reasonable size.
为了实现最佳性能,启用语句缓存并为其设置一个合理大小很重要。
Figure 11 shows an example of the syntax validation error that occurs after you set the statement terminator to an exclamation point (!), and do not update an existing statement terminator.
图11显示的是将语句结束符设置为感叹号(!)但未修改现有语句结束符之后所出现的语法验证错误。
The SET OPTIMIZATION ENVIRONMENT FACT statement can be used to specify a list of tables that can be considered as fact tables during star join optimization for all queries in the current session.
SETOPTIMIZATIONENVIRONMENTFACT语句针对当前会话的所有查询,用于指定一个在星型连接优化中可被视为事实表的表清单。
ISOLATION level is set at the session level using set ISOLATION, set at the SQL statement level using the WITH clause or set at the database level using a database Configuration parameter.
使用SETISOLATION在会话级、使用with子句在sql语句级或使用数据库配置参数在数据库级设置隔离级别。
We are ready to exert joint efforts with other parties to achieve the goals set in the September 19 joint Statement through the Six-Party Talks.
我们愿与各方共同努力,通过六方会谈进程,实现9·19共同声明的各项目标。
Making changes to the SQL statement will affect the result data set being shown in the table or chart.
更改sql语句会影响在表或图中显示的结果数据集。
The "SET integrity" statement specifies that the MQT is to have integrity checking turned on without being checked for integrity violations.
“SETINTEGRITY ”语句指定,MQT将打开完整性检查,而不检查完整性违反。
Users can also use the set encryption password statement to set an encryption password for a session.
用户还可以使用SETENCRYPTIONpassword语句为一个会话设置一个加密密码。
The set clause of the UPDATE statement replaces the existing document in a given row with a new document.
UPDATE语句的set子句用一个新文档替换给定行中的现有文档。
After being created, the MQT is in check pending state (see Demystifying table and table space states), and cannot be queried until the SET INTEGRITY statement has been executed against it.
MQT被创建之后,便处于检查暂挂状态(请参阅DB 2基础:阐明表和表空间的状态),在对它执行SETintegrity语句之前,不能查询它。
The WHILE statement defines a set of statements to be executed until a condition that is evaluated at the beginning of the WHILE loop is false.
while语句定义了一个语句集合,如果在WHILE循环开始时某个条件的求值结果为false,那么就将执行这个语句集合。
The WHILE statement defines a set of statements to be executed until a condition that is evaluated at the beginning of the WHILE loop is false.
while语句定义了一个语句集合,如果在WHILE循环开始时某个条件的求值结果为false,那么就将执行这个语句集合。
应用推荐