In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code.
在这个例子中,我们选择修改CREATE procedure语句而不是修改源代码。
Listing 9 contains a code example of the SQL CREATE procedure statement used to register an RPG program as an external stored procedure.
清单9包含一个用于将一个R PG程序注册为一个外部存储过程的SQLCREATE PROCEDURE语句的代码示例。
In this example we will create an existing table in Sybase for the Sybase catalog stored procedure sp_tables and then create a WebSphere Information Integrator nickname for this existing table.
在这个示例中,我们将在sybase中为sybase编目存储过程sp _ tables创建一个现有表,然后为该现有表创建一个DB 2 II昵称。
An example would be the need to first create the set of tables before creating the stored procedure that access them.
例如,需要在创建访问一组表的存储过程之前,先创建这组表。
For example, create a script named rawdevsize.sh as a wrapper that calls the rawdevsize program from within the SQL stored procedure, as shown in Listing 6.
例如,创建一个名为rawdevsize . sh的脚本作为包装器,它在SQL存储过程中调用rawdevsize程序,如清单6所示。
I've read this can be done, but I haven't found a good example of how to create a COBOL stored procedure that calls a COBOL program.
我看这是可以做到的,但是我还没有找到一个很好的例子,如何创建一个COBOL存储过程调用COBOL程序。
But with this method if for example I'm showing a sales report (from a stored procedure), I have to create a class with all the columns in the query in the client and the server side.
但这种方法例如如果我展示销售报告(从一个存储过程),我必须与所有查询中的列在客户端和服务器端创建一个类。
If your stored procedure returns values that need to be sent back to the client (for example, values calculated in the stored procedure), create output parameters in your stored procedures.
如果预存程序传回的值需要送回给用户端(例如,在预存程序中计算的值),请在预存程序中建立输出参数。
If your stored procedure returns values that need to be sent back to the client (for example, values calculated in the stored procedure), create output parameters in your stored procedures.
如果预存程序传回的值需要送回给用户端(例如,在预存程序中计算的值),请在预存程序中建立输出参数。
应用推荐