Note: if you analyze the Optimized Statement section of the db2exfmt output for the above query, you may notice that the or predicates were converted to their equivalent IN predicates.
注意:如果分析一下以上查询的db 2 exfmt输出的OptimizedStatement部分的话,您会注意到OR谓词被转换成了与它们等效的in谓词。
In our example, this is a simple statement that the body of the message is a particular element from the schema in the types section.
在我们的示例中,这是一个简单的声明,消息的主体是来自类型部分的架构的特殊元素。
Move the pointer over each section of the pie chart to view the percentage for the statement type.
把鼠标指针移动到饼图的每个部分上,就会看到这种语句类型的百分比。
A company statement said the move led to an immediate 80 percent drop in postings to that section.
公司的一份声明说,采取这个举措后,相关栏目的发帖量立即下降了80%。
If more than one STMTPROFILE section matches an executing statement, the guideline that occurs first is selected and applied.
如果有超过一个STMTPROFILE部分匹配某个正在执行的语句,那么将选择并应用出现的第一个准则。
Each member of the team distributes 100 points across four descriptive statements in each section, assigning more points to the statement that best describes the organization.
每个团队成员在每节的四个描述中分配100点,分配最多点的就是组织最合适的描述。
The statement below creates the TAX1120VIEW that you will use in the reporting section.
下面的语句创建了将在报告部分使用的TAX1120VIEW。
Notice that The SQL statement in Listing 7 is the same as the one in Listing 6 in the previous section.
请注意清单7中的SQL语句与前面部分的清单6 中的 SQL 语句相同。
Section 1 of the compositePieIndicators.pl program covers the usage statement and reading in the base pie image, as well as the triangle.vertices
pl程序的第 1部分将涉及用法声明并读入基本的饼图图像,以及 triangle.vertices 文件。
The optimized SQL is located in the section 'optimized Statement' of the db2exfmt output. For example, for the query in Listing 4.
优化后的SQL位于db 2exfmt输出的“OptimizedStatement”部分。
This statement essentially says, "use the CSS information described under the section LargeTitle".
这个声明本质上是说,“使用CSS信息在LargeTitle部分下描述”。
The "profile Information" section of the db2exfmt output can be used to verify that the correct optimization profile and statement profile have been applied to the current query.
db 2 exfmt输出的“ProfileInformation”部分可以用来检验是否已将正确的优化概要文件和语句概要文件应用到当前的查询。
Allocate one or more statement handles (covered in the section above on the structure of an ODBC application).
分配一个或多个语句句柄(在关于ODBC应用程序的结构的上一节曾讲到)。
The example below introduces the access plan basics by analyzing the bad SQL statement we captured in the previous section.
下面的示例通过分析我们在前面小节中所捕获的糟糕查询,介绍访问计划的基础知识。
It's also helpful to add an Implementation details section in the glossary to provide a place to record these details, even though they're not actually part of the problem statement per se.
在词汇表中加入实现细节部分也是很有帮助的,它提供了记录这些细节的地方,就其本身而言,尽管它不是问题说明书的都具有的。
Each section of the Technical Standard begins with a highlighted paragraph in bold text, which is the statement of intent, that all Suppliers must comply with in order to gain certification.
技术标准的每一个部分都由突出的黑体字的部分开始,是对意图的描述,所有的供应商都应该满足以取得证书。
Selecting a statement shows in the lower section the execution details of this statement.
选择一个语句可在底部显示该语句的执行细节。
The EXPLAIN_FROM_CATALOG procedure produces explain information about a statement using the content of the section from the catalog tables.
EXPLAIN_FROM_CATALOG过程将使用目录表中的片段内容生成有关一条语句的解释信息。
The implementation of the stored procedure described in this section addresses those needs because CALL is a SQL statement of its own.
这一节中描述的存储过程的实现解决了这些需求,因为CALL本身是一个sql语句。
Because the archive has been created with the same schema as the active data, the same SQL statement from the previous section can be used here to fetch the order amounts.
由于创建归档数据的模式与活动数据是相同的,因此上一节中的sql语句也同样可以用来获取订单数量。
Since the statement in the STMTKEY element contains the special XML characters , the query text needs to be enclosed in a CDATA section starting with
由于 STMTKEY元素中的语句包含特殊的XML字符 ,因此需要用一个CDATA 部分将查询文本包围起来,CDATA 的开始部分为
The information for each query consists of the input and output SQLDA, the statement text, the SQLCA, the package name, the creator, the section number, and the consistency token.
每个查询的信息包括输入和输出SQLDA、语句文本、SQLCA、包名、创建者、区号和一致性符号。
A debit balance account which is offset against revenue in the revenue section of the income Statement. Examples include sales Discounts and sales returns and Allowances.
收入抵减帐户是一种借方余额帐户,它抵减收益表中收入部分的收入。例如销售折扣、销售退回和折让。
Subject to Section 3 of conditions, if this shipment is to be delivered to the consignee without recourse on the consignor, the consignor shall sign the following statement.
根据第3条规定之条件,如果本批货交与收货人而发货人不负追索之责,发货人必须签署以下声明。
Following identification this section should include a statement of the root cause and state CLOSED in the target date box when this has been verified.
接下来这个部分必须包含对问题根源的陈述,以及当原因经过验证确认后,在目标日期的方框中注明“关闭。”
You have the ability to select columns to display, sort order, and specify an SQL statement for filter criteria, using the filter Options section.
您可以利用FilterOptions部分来选择所要显示的列、分类顺序和指定作为筛选标准的sql语句。
For example, you can use it in combination with a case statement to choose the right aliases, as per the ps examples in the previous section, like Listing 10.
例如,可以按照前一部分中的ps示例,将该命令与case语句结合使用以选择正确的别名,如清单10所示。
Find the section of code that creates and sends the selector statement to the Subscription Manager
找到创建了选择程序语句并将其发送到SubscriptionManager的那部分代码
The results obtained after issuing a section explain are similar to those collected after running the explain statement.
执行一个片段解释所得到的结果与执行explain语句所收集的结果类似。
There are slight differences between section explain and explain statement output in explain table and by the implications to the output generated by the db2exfmt utility.
片段解释和解释表中explain语句的输出与由db 2 exfmt实用工具生成的输出有一些差别。
应用推荐