下一个例子将展示如何调用需要一个参数值的存储过程。
This next example shows how to call a stored procedure that needs a parameter value.
需要有状态上下文的应用程序的例子有很多，例如存储检查过程、产品定制、多页表单向导和很多其他基于线形交互的应用程序。
Examples of applications that require a stateful context include a store checkout process, product customization, multipage form wizards, and many other applications based on linear interactions.
图1显示一个例子，其中一个执行s QL存储过程的任务被安排为每30秒运行一次。
Figure 1 depicts an example where a task to execute an SQL stored procedure is scheduled to run every 30 seconds.
第二个例子展示了一个用于z/OS 的DB2SQL存储过程。
The second example shows a DB2 SQL stored procedure for z/OS.
清单7展示了一个存储过程的例子，该存储过程根据业绩评分评定雇员新的工资和奖金。
Listing 7 shows an example of a stored procedure that determines an employee's new salary and bonus, depending on their performance rating.
如果正在使用用c语言编写的外部存储过程，那么既可以使用日志存储过程，也可以直接使用日志调用，后者可以跳过存储过程(参见例子)。
If you are using external stored procedures written in c, you can use either logging stored procedures, or the logging calls directly, bypassing stored procedure wrappers (see example).
下面这个 SQL-PL存储过程TESTSP的例子显示了日志存储过程的用法。
The following sample example of SQL-PL stored procedure TESTSP shows use of the logging stored procedures.
以下存储过程就是一个例子，两种平台上都可以构建这个存储过程，无需任何更改。
As an example, the following stored procedure can be built on both platforms without any changes.
在接下来的例子中，字符串'hello '被传递给存储过程，当存储过程返回时，hello被替换为该存储过程返回的值。
In this next example, the string 'hello' is passed into the stored procedure, and when it returns, hello is replaced with the return value of the procedure.
此模式的第一个例子是Bean的CRUD方法的实现，这些方法通过调用关系数据库存储过程实现（如通过JDBCCallableStatements）。
The primary example of this pattern is implementation of the bean's CRUD methods via calls to relational database stored procedures (such as via JDBC CallableStatements).
我看这是可以做到的，但是我还没有找到一个很好的例子，如何创建一个COBOL存储过程调用COBOL程序。
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程序。
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.
应用推荐