The second example shows a DB2 SQL stored procedure for z/OS.
第二个例子展示了一个用于z/OS 的DB2SQL存储过程。
Executing the modified DDL to catalog the SQL stored procedure.
执行修改后的DDL，以编目s QL存储过程。
Complete the following steps to create a simple SQL stored procedure.
通过以下步骤来创建一个简单SQL存储程序。
Listing 4. Source code for change_password_admin SQL stored procedure.
清单4 . change _ password_adminSQL存储过程的源代码。
SQL stored procedure is pre-compiled and bound to a package at creation time.
SQL存储过程是预编译的，并且是在创建时绑定到一个包上的。
The SQL stored procedure that executes the ADD CHUNK command reads these results.
执行addCHUNK命令的SQL存储过程将读取这些结果。
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 desired, you can develop and deploy an equivalent SQL stored procedure using DB2's command line processor.
如果需要，您可以使用DB2的命令行处理器开发和部署一个等价的SQL存储过程。
Therefore, each chunk that you add has to have a unique pathname that is created by the SQL stored procedure.
因此，SQL存储过程必须为添加的每个块创建一个惟一的路径名。
Figure 1 depicts an example where a task to execute an SQL stored procedure is scheduled to run every 30 seconds.
图1显示一个例子，其中一个执行s QL存储过程的任务被安排为每30秒运行一次。
The user can also "copy" the external SQL stored procedure by checking the radio button Deploy by building the source.
用户还可以通过选择Deploy bybuildingthe source单选按钮，“复制(copy)”外部SQL存储过程。
This is still only the empty SQL stored procedure, without the actual contents to implement the required functionality.
这依然是一个空的SQL存储过程，没有实现所需功能的实际内容。
When an external SQL stored procedure is initially deployed, the source as well as the DBRM dataset name are cataloged.
当最初部署外部SQL存储过程时，要编目源数据集和DBRM数据集的名称。
XQuery queries can only be defined within dynamic cursors. The following is NOT allowed within a SQL stored procedure.
XQuery查询只能在动态游标中定义。
However, they can be resolved if you embed the INSERT statements above in an SQL stored procedure with a little extra logic.
但是，如果将上述insert语句嵌入到一个包含一点额外逻辑的SQL存储过程中，就可以解决这个问题。
Copying and modifying the SQL stored procedure DDL for changes due to SCHEMA name, collection ID, and WLM application environment.
根据schema名称、集合id和WLM应用程序环境的变化复制和修改SQL存储过程DDL。
Create a database connection, a corresponding data Development project, and an unqualified SQL stored procedure in your project (Figure 10).
创建数据库连接，创建相应的DataDevelopment项目，在项目中创建SQL存储过程(图10)。
The SQL stored procedure searches for a matching free chunk in the free_chunks table and USES this information for the ADD chunk function call.
SQL存储过程在free_chunks表中搜索匹配的空闲块，并将该信息用于ADDchunk函数调用。
It is easy to create SQL stored procedures, so for each stored procedure with INOUT and OUT parameters, you can create a wrapper stored procedure.
SQL存储过程的创建十分容易，因此，对于每个带有INOUT和OUT参数的存储过程，都可以创建一个包装器存储过程。
To rebind the package for a stored procedure, drop and recreate it with new REOPT level, or rebind the package for this specific SQL stored procedure.
要重新绑定存储过程的包，我们需要先删除它，然后再重新创建绑定新REOPT级别的存储过程，或者为这个特定的SQL存储过程重新绑定一个包。
Shredding into this schema is therefore more challenging, but can be achieved with a SQL stored procedure (see the script found in the Download section).
因此，分解到这种模式更具有挑战性，但是可以通过SQL存储过程来完成(请参阅下载小节中的脚本)。
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所示。
The process for building an SQL stored procedure that accesses XML data is no different from building an SQL procedure that accesses non-XML data. Here's one way to do so
构建访问XML数据的SQL存储过程的过程与构建访问非XML 数据的 SQL 过程没什么不同。
Whether you use an open source, commercial, or custom compensation framework, you still must provide the method, SQL, or stored procedure to invoke to reverse the database update operations.
无论使用开源、商业还是自定义补偿框架，您都必须提供可以调用的方法、SQL或存储过程来反转数据库更新操作。
Now, convert the visual mining flow into SQL statements we can paste into the stored procedure body.
现在，将可视的挖掘流转换为sql语句以便粘贴到存储过程主体中。
These elements differ in that the SQL code for a stored procedure is defined and stored in the database itself, then called from the application.
不同之处在于，用于存储过程的SQL代码定义并存储在数据库本身中，然后从应用程序中进行调用。
Grouping SQL statements into a stored procedure can reduce the number of network interactions to complete a transaction.
将sql语句组合成存储过程可以减少完成事务的网络交互数。
The following sample example of SQL-PL stored procedure TESTSP shows use of the logging stored procedures.
下面这个 SQL-PL存储过程TESTSP的例子显示了日志存储过程的用法。
It provides the SQL editor control to enter the SQL body for the stored procedure.
它提供SQL编辑器控件以输入存储过程的SQL主体。
Since many IBM i developers are familiar with stored procedures, SQL procedure calls are a natural solution.
由于许多IBMi开发人员都熟悉存储过程，因此 SQL过程调用自然成为一个解决方案。
应用推荐