设置更新存储过程的步骤
本文描述的更新存储过程允许对本机存储在数据库中的XML文档进行部分更新。
The update stored procedure described in this article enables partial updates to XML documents stored natively in the database.
通过创建更新存储过程，可以更新数据库中的XML文档而无需将其交给客户机。
By creating an update stored procedure it is possible to update XML documents in the database without needing to bring them over to the client.
还可以查看并更新表和视图中所包含的数据，并执行存储过程和函数。
You can also view and update the data contained in tables and views, and execute stored procedures and functions.
无论使用开源、商业还是自定义补偿框架，您都必须提供可以调用的方法、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.
这包括使用传统更新方法的现有程序和能够利用存储过程调用的外部接口。
This includes existing programs using traditional update methods and external interfaces capable of utilizing stored procedure calls.
想要执行某个事务(例如更新订单或者购买某个产品)的应用程序，只需从应用程序中调用存储过程。
Applications wanting to begin a transaction, such as updating an order or purchasing a product simply need to invoke the appropriate stored procedure from the application.
通常，我们会在命令行中使用clp或db2命令编辑器来执行这个存储过程，以实现对日志参数的更新。
Generally, you will execute this stored procedure either from command line using CLP or DB2 command editor to update the logging parameters.
该存储过程接受两个输入参数，即雇员号和一个评分，然后根据给定的评分更新该雇员的工资和奖金。
This stored procedure accepts two input parameters, the employee number and a rating, then updates the employee's salary and bonus depending on the rating given.
从数据持久化的角度看，进行数据库更新操作的最快速的方式是将本地事务与数据库存储过程一起使用。
From a data-persistence standpoint, the fastest way to perform a database update operation is to use local transactions combined with database stored procedures.
在这次发布中其他一些特性也没有达到预定目标，如对存储过程、类型转换、枚举和大数据块更新的支持。
Some other features that are not making it to this release are support for stored procedures, type-conversions, enums and bulk updates.
例如，一个存储过程可以更新某些DB 2udb数据，并执行CICS事务，如果这些操作中任何一个失败，则整个事务将回滚。
For example, a stored procedure could update some DB2 UDB data, execute a CICS transaction, and be assured that if any of these operations was to fail, the entire transaction would be rolled back.
要更新模式，用户需要分别注册新旧模式，然后调用 XSR_UPDATE存储过程。
To update a schema, a user needs to register both the schemas independently and then call the XSR_UPDATE stored procedure.
也可以使用类似的存储过程限制或执行相反的操作(更新关系列导致同时更新XML文档)。
The opposite operations can either be restricted or can be done using similar stored procedures (update in the relational column updates the XML document too).
如果您已经有一个存在的数据库，并需要使用该存储过程所提供的功能，就需要在安装db 2V8.2.2之后使用db2updv8实用程序更新您的数据库。
If you have an existing database and you want to use the function provided by this stored procedure, you need to update your databases after you install db2 V8.2.2 using the db2updv8 utility.
用于检索和更新自动维护策略的存储过程
Stored procedures for retrieving and updating automatic maintenance policies
注册之后，可以用以下存储过程将现有模式更新为新模式。
After registration, the following stored procedure can be used to update the existing schema with the new one.
不管使用何种方法，初步填充完一个昵称的统计信息之后，就可以使用 NNSTAT存储过程或ControlCenter的昵称统计信息更新程序不断更新它们。
Once statistics for a nickname have been initially populated by any method, they can be kept up-to-date using the NNSTAT stored procedure or Control Center's nickname statistics update facility.
DB 2 9.5提供了以下存储过程，用于更新和检索维护策略和维护窗口。
DB2 9.5 provides the following stored procedures for updating and retrieving automatic maintenance policies and the maintenance Windows.
因此，该流程结合使用了几种Lombardi技术，包括Coach、SQL、存储过程调用、Ajax更新和异步消息传递。
The process therefore USES a combination of Lombardi techniques, including Coaches, SQL, stored procedure invocation, Ajax updates and asynchronous messaging.
使用DB 2 . UPDATE_SP_CONFIG存储过程更新日志标记。
UPDATE logging tokens using the DB2.UPDATE_SP_CONFIG stored procedure.
这个存储过程的接口允许我们配置更新频率、语言、文本格式和CCSID。
The procedure's interface allows us to configure the update frequency, language, text format, and CCSID.
通过这些视图进行的配置更改更新在部署管理器配置存储库中，然后通过节点同步过程分发到联合的节点。
Configuration changes made through these views are updated in the deployment manager configuration repository and then distributed to federated nodes through the node synchronization process.
当您为企业中的组织分别配置了存储库，更新了过程之后，您将准备在您的社区中应用基于资产的开发。
With the repository configured and the processes updated for the respective organizations in the enterprise, you are prepared to apply asset-based development within your communities.
更新过程可以是一个调用SYSPROC . SYSTS_CRTCOL配置的定时更新，也可以是通过调用UPDATE存储过程进行的手动更新。
This can either be a scheduled update that was configured when calling SYSPROC.SYSTS_CRTCOL, or a manual update by calling the update stored procedure.
该存储过程支持对本机存储在数据库中的XML文档进行部分更新。
This stored procedure enables partial updates of XML documents stored natively in the database.
UPDATE_SP_CONFIG存储过程对共享内存进行更新，并将所有的日志标记写入一个配置文件中。
The DB2.UPDATE_SP_CONFIG stored procedure updates the Shared memory and writes all logging tokens to a configuration file.
使用基于Web的中心存储库来为分发储存软件，可以大大简化安装和更新开发环境中工具的过程。
Using a central Web-based repository to store your software for distribution can greatly simplify the installation and update process of the tools in your development environment.
您可以下载更新后的存储过程的源代码和jar文件，并根据说明安装它。
You can download the source code and a jar file for the updated stored procedure, and follow the instructions for installing it.
可以使用SQL存储过程来检索和更新这些策略。
SQL stored procedures are provided to retrieve and update these policies. Using the stored procedures, you can perform the following tasks.
应用推荐