在应用服务器上程序嵌入的SQL可能使用SQL系统日期子句。
SQL embedded in programs on the application server might use the SQL system date clause.
除了嵌入的原始sql查询以外,没有保留用于查询数据的一个或多个表的表示(“ FROM ”子句)。
Beyond the embedded original SQL query, no representation is kept of the table or tables that were queried for data (the "FROM" clause).
更新29给出另一个示例,它使用COPY子句只获取客户的地址并在return子句中把修改后的地址嵌入新的“sendto”元素。
As another example, Update 29 USES the COPY clause to only get the customer's address, and the RETURN clause to embed the modified address in a new "sendto" element.
在DB 29中,可以使用passing子句向sql语句中嵌入的XQuery传递运行时参数,但是不能向XQuery中嵌入的SQL传递参数。
In DB2 9, you are able to pass runtime parameters to the XQuery embedded in the SQL statement using the passing clause but you could not do the same for SQL embedded inside an XQuery.
在DB 29中,可以使用passing子句向sql语句中嵌入的XQuery传递运行时参数,但是不能向XQuery中嵌入的SQL传递参数。
In DB2 9, you are able to pass runtime parameters to the XQuery embedded in the SQL statement using the passing clause but you could not do the same for SQL embedded inside an XQuery.
应用推荐