此外,这些类型的sql语句对适当的索引和数据库设计最敏感,因此查看以下指示,获取实现最优性能的技巧。
Additionally, these kinds of SQL statements are the most sensitive to proper indexing and database design, so look to the following Pointers for tips for optimal performance.
我们编辑了SQL脚本文件,并更改了前两个 SQL语句,以指示希望使用的数据库名称
We edited the SQL script file and changed the first two SQL statements to indicate the desired database name
if语句支持一个可选的else子句,指示当布尔表达式计算为False时应该处理的程序语句块。
The if statement supports an optional else clause that indicates a block of program statements that should be processed if the Boolean expression evaluates False.
这个标注指示pureQuery的DDL代码生成系统恰当地生成用于定义主键的CREATEINDEX语句。
This particular annotation indicates to the pureQuery's DDL code generation system to properly generate the CREATE INDEX statement for defining the primary key.
注意,在清单1中,autocommit值设置为true,这将指示DBMS应该在各数据库语句之后提交本地事务。
Notice in Listing 1 that the autoCommit value is set to true, indicating to the DBMS that the local transaction should be committed after each database statement.
在DB 2fori 6.1发布之前,SQLUpdate和insert语句能够使用一个值为- 1的指示符变量,将支持空值的列设置为空值。
Prior to the DB2 for I 6.1 release, SQL Update and Insert statements could use an indicator variable with a value of -1 to set a null capable column to the null value.
空指示符值在SQLFETCH语句执行过程中填充。
The null indicator values are populated during the execution of the SQL FETCH statement.
有了正确的xpath语句后,我们可以将其嵌入到XQuery,它指示我们希望在哪一个表列上运行XPath查询?
Once we have the correct XPath statement, we can embed it into an XQuery that indicates which table column we want to run the XPath query on.
空指示符值在执行SQLupdate语句之前通过RPG handle_update子过程设置。
The null indicator values are set by the RPG HANDLE_UPDATE sub-procedure prior to executing the SQL UPDATE statement.
应用恰当的语句或图标指示特别的危害。
Appropriate wording or symbols are to be added to indicate specific hazards.
可将当前语句指示器拖到另一行,以跳过或重新执行代码。
You can drag the current statement indicator to another line to either skip or re-execute code.
可将当前语句指示器拖到另一行,以跳过或重新执行代码。
You can drag the current statement indicator to another line to either skip or re-execute code.
应用推荐