DB2 can use an index defined on a single relational column to answer any equality or range predicate on this column.
DB 2可以使用定义在单个关系列上的索引来响应此列上的任何等式谓词或范围谓词。
If you use double quotes around your string-based query predicate, instead of pairs of single quotes, you'll get a syntax error.
如果在基于字符串的查询谓词周围使用双引号,而不是单引号,就会收到语法错误。
There is also a new feature for the LIKE predicate that makes it possible to use a column reference as pattern expression.
LIKE谓词有一个新特性,允许使用列引用作为模式表达式。
Use BC mode, or append a predicate [1] onto the select expression.
使用BC模式,或者在 select表达式后加上谓词 [1]。
Update transactions first read a specific document based on an XQuery predicate, and then use it to update the original copy of that document in the database.
更新事务首先根据一个XQuery谓词读取一个特定文档,然后使用它更新数据库中这个文档的原副本。
When you use the partitioning key in the join predicate, a final consideration needs to be mentioned.
如果在连接谓词中使用分区键(partitioning key),最后还有一点考虑需要顾及。
If you did not use this same sample data, remove or change the xmlexists where predicate.
如果使用的不是该样例数据,那么需要移除或更改xmlexists的谓词。
The use of table names is simpler, but using table identifiers is a more powerful mechanism because it can refer to a derived quantifier, such as an 'xmlexists' predicate.
使用表名比较简单,但是使用表标识符的功能更加强大,因为它可以指代一个派生的限定符,比如一个 “xmlexists” 谓词。
To delete only one of the phone elements, you can use a predicate in the MODIFY clause, such as modify do delete $new/customerinfo/phone[@type = "work"].
如果只希望删除 “phone”元素之一,那么可以在MODIFY 子句中使用一个谓词,比如 modifydodelete $new/customerinfo/phone[@type = "work"]。
The problem is that the predicate with the fn: upper-case function prevents the use of XML indexes in DB2.
问题是如果使用包含fn:upper - case函数的谓词,就不会使用DB 2中的xml索引。
They use the SQL/XML predicate XMLEXISTS to select XML documents based on one or multiple conditions which are expressed in XQuery notation.
它们使用SQL/XML谓词XMLEXISTS根据一个或多个条件选择 XML文档,条件用XQuery表示法表示。
As an alternative to value comparisons, you can use the self axis (denoted by a dot ". ") to express a "between" predicate.
除了值比较,还可以使用self轴(由点“。”表示)来表达“between”谓词。
While Update 26 USES an SQL predicate to select the document, Update 27 USES an XQuery predicate and avoids the use of SQL completely.
更新26使用SQ l谓词选择文档,而更新27使用XQuery谓词,完全避免使用SQL。
Predicate (which is the is-factor method I defined earlier in Listing 2 - note the heavy use of first-class functions), returning the Numbers that match.
谓词(我在之前的清单2中定义的is - factor方法—请注意一类函数的大量使用),返回匹配的数字。
When you use transform expressions in SQL update statements, you rarely have a filtering predicate in the COPY clause but rather in the SQL WHERE clause.
在SQL更新语句中使用转换表达式时,很少在COPY子句中使用筛选谓词,通常是在 SQL WHERE 子句中进行筛选。
A view could use the value of this global variable in a predicate to select only those rows for which the user's department is assigned.
视图可以在谓词中使用该全局变量的值,从而只选择分配给用户所在部门的行。
Otherwise, use the predicate condition (p) passed as a parameter.
否则,使用谓语条件(p)作为参数传递。
Knowing this, we use a simple complete call specifying the predicate and object to get a list of documents in our system using the software document definition.
知道了这一点,我们就可以用一个简单的complete调用指定谓语和宾语,用soft ware文档定义在我们的系统中获得一个文档列表。
When you use position in the predicate-that is, within the square brackets () -the index is relative to the element's parent.
当您在谓词—即方括号()—中使用position时,索引是相对于元素的父元素的。
Then supposed you want the first CD; you can use a predicate to get that CD, like this: /cds/cd[1].
假设需要第一张唱片,可以使用谓词来实现:/cds/cd[1]。
Since Query 1 expresses the join predicate on the books table, DB2 9.1 and 9.5 perform a table scan on authors and then use the index AUTHORIDX1 to probe into the books table.
由于查询1表达了books表中的连接谓词,所以DB 2 9.1和9.5执行一个扫描authors的表,然后使用索引authoridx 1查找books表。
In order to use this technique, the SQL must provide a predicate on the first key column of the partitioning index.
为了使用这种技术,SQL必须提供分区索引的第一个键列上的一个谓词。
Full-text searches use the CONTAINS predicate to locate rows that have specified text in a given column.
全文搜索使用CONTAINS谓词来查找在给定列中包含指定文本的行。
According to different internal structures, single use of the same word form of nouns "n is n" can be divided into two kinds: the subject-predicate structure and the tight structure.
单用的名词同语式“N是N”根据内在结构的不同,我们把它分为两类主谓结构的名词同语式和紧缩结构的名词同语式。
According to different internal structures, single use of the same word form of nouns "n is n" can be divided into two kinds: the subject-predicate structure and the tight structure.
单用的名词同语式“N是N”根据内在结构的不同,我们把它分为两类主谓结构的名词同语式和紧缩结构的名词同语式。
应用推荐