The CREATE transform statement enables an existing function to be used as a transform function.
CREATETRANSFORM允许将现有的函数用作转换函数。
In Listing 8, you are passing the values of firstname, lastname, and office from the Employee bean into the transform statement.
在清单8中,把firstname、lastname和office的值从Employeebean传递给转换语句。
Most of the examples in this article show the transform expression in an SQL UPDATE statement.
本文中的大多数示例在SQLupdate语句中使用转换表达式。
Also, to explore and test the new update capabilities initially, you may find it convenient to embed the XMLQUERY function with the transform in a SELECT statement rather than an update.
另外,在研究和测试新的更新功能时,在select语句(而不是update语句)中嵌入包含转换表达式的XMLQUERY函数可能更方便。
We then created a page design element within the Notes database, which contained the XSLT style sheet code that would transform the XML document into an SQL statement.
然后我们在Notes数据库中创建一个页面设计元素,它包含了将XML文档转换成sql语句的xslt样式表代码。
The application simply sends an SQL UPDATE statement with an embedded XQuery transform expression to the DB2 server (Figure 2).
应用程序只需向DB 2服务器发送一个包含XQuery转换表达式的SQLupdate语句(图2)。
The servlet then ran a transform on the XML document using an XSLT style sheet also stored in the Domino application, resulting in an SQL statement.
然后servlet使用也存储在Domino应用程序中的 XSLT样式表对XML文档运行转换,从而生成一个SQL 语句。
Update 2 is an SQL SELECT statement with the same XMLQUERY function, transform expression, and WHERE clause, as in Update 1.
更新2是一个SQLselect语句,其中包含与更新1相同的XMLQUERY函数、转换表达式和where子句。
The SQL compiler USES them to transform a statement into a more optimized form, thus improving the access path to the required data.
SQL编译器使用信息约束将语句转化成更优的形式,从而改善对所需数据的访问路径。
If the SQL statement is badly coded, it is difficult for the optimizer to transform the query, leaving fewer options available for choosing an optimal access path.
如果sql语句设计得很糟,优化器就很难转换查询,在选择最佳访问路径时的选择就很少。
You can either set a transform manually using the set CURRENT default transform group statement, or you rely on the already established default transform group DB2_PROGRAM.
可以使用SETCURRENTDEFAULTTRANSFORMgroup语句手动设置转换,也可以依靠已经建立的默认转换组DB 2 _ PROGRAM。
Alternatively, you can make the transform explicit by including the whole TREAT (...) expression as in statement (5) (with longitude and latitude replaced by the given values).
也可以通过包含语句(5)中的整个TREAT(…)表达式(用给定值替换longitude和latitude)来执行显式转换。
In order for a PERL program to transform a dynamic SQL statement into executable form, you need to first use the prepare method, and then bind parameters using the bind_param method.
为了让Perl程序将动态sql语句转换成可执行的格式,需要首先使用prepare方法,然后使用bind _ param方法来绑定参数。
In order for a PERL program to transform a dynamic SQL statement into executable form, you need to first use the prepare method, and then bind parameters using the bind_param method.
为了让Perl程序将动态sql语句转换成可执行的格式,需要首先使用prepare方法,然后使用bind _ param方法来绑定参数。
应用推荐