The return value of any function is the result of the last expression in that clause (in our examples there is only one line).
任何函数的返回值都是子句(在我们的示例中只有一行)中最后一个表达式的结果。
The FROM SQL clause defines the specific function that will be used to transform a value to a built-in data type value representing the structured type.
FROMsql子句定义了特定的函数,可以使用该函数将将一个值转换成表示结构化类型的内置数据类型。
The type clause also delineates the incoming key and value, which in the case of reading a file are the byte count and the line of text, respectively.
类型子句也指定了传入键和值,这对于读取文件分别是字节数和文本行数。
If the statement is not successful, the value of SQLERRNUM is captured and returned to the caller using the return statement and the RETURNS clause.
如果语句不成功,将使用return语句和returns子句捕捉SQLERRNUM的值并返回给调用者。
This clause is used to assign a value (possibly containing a list of several items) to a variable that can be used in other clauses of the FLWOR expression.
该子句用于将一个值(可能包含一个由多项组成的列表)赋给一个变量,这个变量可以在FL WOR表达式的其他子句中使用。
Parameter MARKER: an application may wish to call the same query multiple times, only changing specific values each time (ex: parameters sent to a stored procedure, or a value in a WHERE clause).
参数标志(PARAMETER MARKER):应用程序可能希望多次调用同一个查询,每次调用时只改变特定的值(例如,发送给存储过程的参数,或者where子句中的值)。
The let clause assigns a value or sequence to a variable.
let子句为一个变量赋一个值或一个序列。
The return clause constructs a new product element for each distinct ProductID value.
return子句为每个不同的productid值构造一个新的“product”元素。
When using the CREATE FIELD statement, make sure to specify each clause in the correct order (TYPE, NAMESPACE, NAME, VALUE).
当使用CREATEfield语句时,请确保按照正确的顺序指定每个子句(TYPE、NAMESPACE、NAME和VALUE)。
We can mix variables passed by value and by reference easily within the use clause, and they will be handled without any problem.
我们可以将按值和按引用传递的变量轻松地混合到 use子句中,并且可以顺利地处理这些变量。
Copy: the copy clause of the transform expression binds the source XML value to a variable.
copy:transform表达式的copy子句将源xml值绑定到一个变量。
The VALUES clause also includes a casting function for the user-specified value of the OID column because the value must be cast into the REFERENCE type of the target table.
values子句还为用户指定的oid列的值包括了一个casting函数,因为该值必须强制转换成目标表的REFERENCE类型。
Once the code has iterated over all the elements in the tuple, it enters the else clause of the for loop, which prints out the value of the count variable.
一旦代码已经迭代了tuple中的所有元素,它将进入for循环的else子句,打印count变量的值。
Because the IfExpr is in an expression, unlike a programmatic XSL: if, the else clause is required so there will always be a value.
由于IfExpr是表达式而不是程序性的xsl:if,因此必须有else子句以保证表达式有一个结果。
The if clause determines whether the value of the ResponseRequested sub-element for a given comment is equal to Yes.
if子句判断一条给定评论的ResponseRequested 子元素的值是否等于 “Yes”。
SeenGuardClauseAt: the value of the program counter when the logging guard clause is discovered in the analyzed code.
seenGuardClauseAt:在所分析的代码中发现日志监护子句时,程序计数器的值。
The result of that subquery then becomes a value in the WHERE clause expression
它的结果会成为where语句表达式中的一个值。
Include WHERE clause predicates for every column on the row to see if each column value is the same as its original value.
在行的每个列中包含where子句谓词,来确定每列的值是否与其初始值相同。
The WHEN clause of the trigger can be used to check if the new value is validated or not validated according to any of the specified schemas.
触发器的when子句可以用来检查是否根据任何指定模式对新值进行了验证。
You can use a scalar subquery to select a specific value that will be used in the expression of the WHERE clause.
可以使用标量子查询选择将用于where子句的表达式中的特定值。
The SQL WHERE clause further restricts the target XML documents to those found only in rows in which the client's "status" is of a certain value (" Silver, "in this method).
SQLwhere子句进一步将目标XML文档限制为只在这样的行中找到的文档,这些行中客户的“status ”是一个确定值(在本例中是“Silver ”)。
With a value of Changed, only the Key fields and the original values of the fields that were changed are passed in the WHERE clause.
如果选择的值是Changed,那么只有Key域和要修改的域的原来值会传递到 WHERE 子句中。
The WHERE clause invokes the XMLExists function, specifying an XPath expression that prompts DB2 to navigate to the "zip" element and check for a value of 95116.
WHERE 子句调用XMLExists函数,指定一个XPath表达式,这个表达式使DB2找到 "zip"元素并检查元素值是否为 95116。"
As you might imagine, the XQuery where clause enables you to filter results based on the value of the zip element in your XML documents.
与您想像的一样,通过XQuerywhere子句可以根据XML文档中zip元素的值来过滤结果。
You also see that the "set" clause assigns a new value to the XML column "info", and that this new value is the result of an XMLQUERY function.
还可以看到“set”子句给xml列“info”设置一个新值,这个新值是一个XMLQUERY函数的结果。
You already know that EMPNO will be equal to the value '000010' because that is what the WHERE clause tells DB2 to do.
您已经知道了empno将等于值“000010”,因为那就是where子句要DB 2做的事。
The where clause is true (and the address is retained) only if the value of this zip element is equal to 95116.
只有当这个zip元素等于95116时,where子句才为true(相应的地址被保留)。
The value should be a string that you want to be added to the end of the where-clause when querying the table.
该值应该是一个字符串,在查询表时,希望将该字符串添加到where子句的后面。
If you add an order by clause, to order by the extracted city value, the result set still remains the same: Paris, Paris, and Paris are treated as the same value.
如果通过添加order BY子句按提取的city值排序,那么结果集仍然是相同的:paris、paris和paris被当作相同的值。
If you add an order by clause, to order by the extracted city value, the result set still remains the same: Paris, Paris, and Paris are treated as the same value.
如果通过添加order BY子句按提取的city值排序,那么结果集仍然是相同的:paris、paris和paris被当作相同的值。
应用推荐