A table- or field-name change would break an embedded SQL statement, and a URL change would break an embedded Ajax call.
表名或字段名的更改会破坏嵌入式的SQL语句,URL 的更改则会破坏嵌入式的Ajax调用。
The embedded SQL statement casts the manager names in the unit table into an XML type (in this case into an XML string), and feeds them into the XQuery.
嵌入式sql语句将unit表中的主管姓名强制转换为xml类型(本例中为xml字符串),然后将其提供给XQuery。
Although db2-fn: sqlquery allows embedding an SQL statement inside XQuery, currently it is not possible to have regular SQL-style parameter markers in the embedded SQL statement.
尽管db 2 - fn:sqlquery允许在XQuery内嵌入sql语句,但目前还不能在嵌入式sql语句中使用参数标记。
For this article, I will be using a combination of fixed-list dynamic SQL and static embedded SQL (for the UPDATE statement) to create a format-based handler.
对于本文,我将结合使用固定列表动态sql和静态嵌入式SQL(用于update语句)来创建一个基于格式的Handlder程序。
A call is issued to the RPG CLOSE_SQL_CURSOR sub-procedure which contains the embedded SQL CLOSE statement.
一个调用被发送到RPG close_sql_cursor子过程,该子过程包含嵌入的SQLclose语句。
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传递参数。
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)。
For example, suppose the following static SQL statement is found in an embedded-SQL application.
例如,假设在一个嵌入式SQL应用程序中有以下的静态sql语句。
For example, suppose the following static SQL statement is found in an embedded-SQL application.
例如,假设在一个嵌入式SQL应用程序中有以下的静态sql语句。
应用推荐