Create an SQL stored procedure.
创建一个SQL存储过程。
The second example shows a DB2 SQL stored procedure for z/OS.
第二个例子展示了一个用于z/OS 的DB2SQL存储过程。
Implement the space check function as an SQL stored procedure.
将空间检查功能实现为一个SQL存储过程。
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存储过程将读取这些结果。
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存储过程必须为添加的每个块创建一个惟一的路径名。
XQuery queries can only be defined within dynamic cursors. The following is NOT allowed within a SQL stored procedure.
XQuery查询只能在动态游标中定义。
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数据集的名称。
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函数调用。
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存储过程来完成(请参阅下载小节中的脚本)。
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 过程没什么不同。
The process therefore USES a combination of Lombardi techniques, including Coaches, SQL, stored procedure invocation, Ajax updates and asynchronous messaging.
因此，该流程结合使用了几种Lombardi技术，包括Coach、SQL、存储过程调用、Ajax更新和异步消息传递。
In detail, it includes the comparison of simple stored procedure with SQL, stored procedure with parameters, and use stored procedure to update database table.
具体包括用存储过程与用SQL语句的对比、使用带参存储过程以及通过存储过程进行数据库表的更新。
In detail, it includes the comparison of simple stored procedure with SQL, stored procedure with parameters, and use stored procedure to update database table.
具体包括用存储过程与用SQL语句的对比、使用带参存储过程以及通过存储过程进行数据库表的更新。
应用推荐