The implementation of the stored procedure described in this section addresses those needs because CALL is a SQL statement of its own.
这一节中描述的存储过程的实现解决了这些需求,因为CALL本身是一个sql语句。
A Data Web Service can contain one or more operations where each is based on a single stored procedure call or SQL statement.
每个DataWebService可以包含一个或多个操作,每个操作都是基于一个存储过程调用或一条sql语句。
You can also define the shape of your select command, be it an SQL statement or stored procedure call, by either discovering the result set or manually defining the one or more returned result sets.
您还可以通过发现结果集或手工定义一个或多个返回结果集,来定义select命令的形式是一条sql语句还是存储过程调用。
One method is to register the external program as a stored procedure and then use the SQL Call statement to run the program with a call to the stored procedure.
一种方法是将外部程序注册为存储过程,然后使用SQLCall语句调用存储过程来运行程序。
Listing 8 shows a CALL statement issued from the CLP to the procedure find_customers defined earlier, and the output generated by the CLP.
清单8显示了从CLP向前面定义的过程find _ customers发出的call语句以及clp生成的输出。
Since you cannot enforce this restriction, data inconsistencies may occur if the remote procedure has a COMMIT or ROLLBACK statement (see the Transaction issues with call statements section below).
因为不能强制实施这一限制,如果远程过程有COMMIT或rollback语句,就可能发生数据不一致(见下面的call语句的事务问题一节)。
Listing 17 shows an example of a CALL statement issued from the CLP to procedure alternate_find_customers and the output generated by the CLP.
清单17显示了从CLP向过程alternate_find _ customers发出的call语句的示例以及clp生成的输出。
ADMIN_CMD Procedure Executes DB2 command line processor (CLP) administrative commands using the SQL CALL statement.
ADMIN_CMD过程使用SQLcall语句执行db2命令行处理器(CLP)管理命令。
A call is issued to the RPG CLOSE_SQL_CURSOR sub-procedure which contains the embedded SQL CLOSE statement.
一个调用被发送到RPG close_sql_cursor子过程,该子过程包含嵌入的SQLclose语句。
I can now call this procedure, return a result set, move that data into a collection, and then use the collection in a FORALL statement, as shown in Listing 3.
现在我们可以调用这个过程来返回结果集,并将数据保存在集合中,然后在FORALL语句中使用这个集合来达成目的。
I can now call this procedure, return a result set, move that data into a collection, and then use the collection in a FORALL statement, as shown in Listing 3.
现在我们可以调用这个过程来返回结果集,并将数据保存在集合中,然后在FORALL语句中使用这个集合来达成目的。
应用推荐