For this example, you will write a stored procedure that retrieves the names and primary email addresses of clients with a certain status, just as you did earlier.
对于本例来说，您将编写一个存储过程来检索具有特定状态的客户的姓名和主电子邮件地址，就像前面所做的一样。
The first part of the example in Listing 8.1 defines a procedure for processing a new order for a new customer.
清单8.1中的示例的第一个部分定义了一个处理新客户的新订单的过程。
In the example in this article, there is a single DDL TAB, because an SQL stored procedure has only a DDL.
在本文的示例中，只有一个ddl选项卡，因为一个SQL存储程序只有一个DDL。
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).
如果正在使用用c语言编写的外部存储过程，那么既可以使用日志存储过程，也可以直接使用日志调用，后者可以跳过存储过程(参见例子)。
If a stored procedure is registered as FENCED, the database manager protects its internal resources (for example, data buffers) from access by the procedure.
如果存储过程被注册为FENCED，那么数据库管理器就禁止过程访问它的内部资源(比如数据缓冲区)。
Figure 3 shows the corrected data lineage report after creating an extension mapping document to track the lineage through the example stored procedure STG_TO_DWH.
在创建扩展映射文档以沿着样例存储过程STG_TO_DWH跟踪沿袭后，生成了如图3所示的正确的数据沿袭报告。
The following sample example of SQL-PL stored procedure TESTSP shows use of the logging stored procedures.
下面这个 SQL-PL存储过程TESTSP的例子显示了日志存储过程的用法。
The second part of the example, which is shown in Listing 8.2, calls the procedure defined in Listing 8.1.
示例的第二个部分如清单8.2所示，它将调用清单8.1中定义的过程。
An example would be the need to first create the set of tables before creating the stored procedure that access them.
例如，需要在创建访问一组表的存储过程之前，先创建这组表。
This procedure has been covered elsewhere, so I won't repeat it, but instead will show you the Relationships page for this example (see Figure 3 below).
这个过程已经在别处讲述过，所以我不再重复，我要说的是将向您显示这个示例的Relationships页面(参阅下图3)。
The second example shows a DB2 SQL stored procedure for z/OS.
第二个例子展示了一个用于z/OS 的DB2SQL存储过程。
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昵称。
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.
在接下来的例子中，字符串'hello '被传递给存储过程，当存储过程返回时，hello被替换为该存储过程返回的值。
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生成的输出。
Although you can listen to the recording, the output from this procedure can be improved. For example.
尽管可以听录音带了，但是该过程的结果还是可以改善的。
The LotusScript code uses BAPIs as remote procedure calls. Here's an example subroutine
LotusScript代码使用BAPI作为远程过程调用。
Figure 2 shows the relationship between the WebSphere Information Integrator nickname, the Sybase existing table and the stored procedure in the example.
图2展示了示例中DB 2 II昵称、Sybase现有表和存储过程之间的关系。
Repeat this procedure for other relevant Validators that would be applied to the dojo libraries folder, (for example, the JSP Syntax Validator and the HTML Syntax Validator).
对其他相关的Validators重复上述的步骤，这些确认器可以应用至dojo库文件夹(例如，JSPSyntaxValidator以及HTML Syntax Validator)。
Analyze the room methodically (you may define a standard procedure, such as always looking from left to right, for example).
系统地分解这个房间(你可以确定一个标准程序，比如总是从左看到右)。
This concept simply applies (or maps) a procedure to a list, as shown in the following example.
这个概念只是将一个过程应用(或映射)到一个列表，如下面的例子所示。
Just as in our first example, the problem here is that the cost of invoking the procedure without actually doing significant work can dominate the cost of the overall job.
正如第一个例子那样，这里的问题是：没有真正执行重要工作的过程的调用成本可能占据了整个作业成本。
The procedure for other operations, for example, updating or deleting a blog entry or updating or deleting a blog entry's comment, is quite similar to these three operations.
其他操作(例如，更新或删除博客条目，或者更新或删除博客条目的评论)的过程与我们介绍的这三个操作非常类似。
We now provide an illustrative example for the ranking procedure and arrangement of ranked equivalent names.
此处提供了关于排名程序以及对等效名称进行排名的例子。
This procedure prevents unknown individuals from re-initializing the device and removing all of the stored objects (for example, keys and certificates).
这个过程防止了未知个人再度初始化设备并除去所有已存储的对象(例如，密钥和证书)。
Here is an example of the second situation where an incorrect number of parameters are passed to the procedure during runtime.
下面是第二种情况的例子，即在运行时传递给过程的参数数量不正确。
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程序注册为一个外部存储过程的SQLCREATEPROCEDURE语句的代码示例。
The procedure in the example above adds the new customer and order, and then goes through the items ordered under order number 2000.
上例中的过程添加了新的客户和订单，然后遍历订单号2000以下的订单项。
Think, for example, of an application that calls a stored procedure with the list of items that a customer has just purchased.
例如，考虑通过客户已购买的项目的列表调用存储过程的应用程序。
If you've checked the option to mark the fact that the stored procedure returns one or more cursors (resultsets), then the resulting records will be displayed, for example as shown in Figure 9.
如果您已选中相应选项，确定了存储过程将返回一个或多个游标(结果集)，则会显示结果记录，图9给出了一个示例。
In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code.
在这个例子中，我们选择修改CREATEprocedure语句而不是修改源代码。
应用推荐