如果使用了受防护的存储过程,那么除了运行存储过程应用程序所需的内存之外,每个用户连接还有两个DB 2代理程序。
If fenced stored procedures are used, then each user connection has two DB2 agents, in addition to the memory required to run the stored procedure application.
图1说明每个银行应用程序使用这些存储过程的方法。
The usage of these stored procedures by each banking application is illustrated in Figure 1.
您可在客户端应用程序中或者作为存储过程来实现此类逻辑。
You can implement this kind of logic in the client application or as a stored procedure.
应用程序通过存储过程直接访问后端数据源。
Applications directly access a back-end data source through stored procedures.
在数据库应用程序中使用存储过程有许多好处,包括减少对网络的使用、提高性能以及降低开发成本。
There are numerous advantages to using stored procedures for your database applications. Some of the benefits include reduced network usage, improved performance, and reduced development cost.
可能需要更多的内存来支持在本地运行或作为存储过程运行的应用程序。
More memory may be needed to support applications that run locally or as stored procedures.
在本文中,我们演示了如何将DB 2命令封装在存储过程中,使得几乎任何应用程序都可以访问任何DB 2命令。
In this article we demonstrated how you can easily make almost any DB2 command available for any application by wrapping it into a stored procedure.
使用SQL存储过程是封装管理应用程序的业务逻辑的最佳方式,这会把开发人员需要编写的代码量减少到最低限度。
Using SQL stored procedures is the best way to encapsulate the business logic of administrative applications because it minimizes the amount of code that developers need to write.
存储过程常常用来整合和集中那些原来在应用程序中实现的逻辑。
Stored procedures are often used to consolidate and centralize logic that was originally implemented in applications.
常常使用外部存储过程访问遗留数据存储和遗留应用程序系统。
External stored procedures are often used to access legacy data stores and legacy application systems.
存储过程对于在服务器上封装应用程序逻辑和数据库访问很有价值。
Stored procedures are valuable for encapsulating application logic and database access on the server.
针对存储过程的每个版本实现一个DB 2CLI应用程序。
A DB2 CLI application was implemented for each version of the stored procedure.
存储过程和DB 2CLI应用程序用于驱动工作负荷。
Stored procedures and a DB2 CLI application was used to drive the workload.
使用存储过程会降低应用程序的可移植性,增加复杂度并降低总体的敏捷度。
Using stored procedures can reduce an application's portability, add complexity, and lower overall agility.
例如,考虑通过客户已购买的项目的列表调用存储过程的应用程序。
Think, for example, of an application that calls a stored procedure with the list of items that a customer has just purchased.
在DB 2V8.2.2之前,一些监控udf和存储过程都不包括各自应用程序编程接口(API)所返回的某些信息。
Before DB2 V8.2.2, some monitoring UDFs and stored procedures didn't include certain information that was returned by their respective application programming interfaces (APIs).
调用存储过程的应用程序将建立连接。
The application that invokes the stored procedure will be the one establishing the connection.
还解释了通过 ADMIN_CMD存储过程在应用程序代码中执行LOADFROMCURSOR操作时的特殊问题。
The article also explains the specialties when LOAD FROM CURSOR operations are executed within application code using the ADMIN_CMD stored procedure.
将需要大量工作以使表示代码不在存储过程中,而在应用程序中。
The effort involved would be tedious enough to make more sense to keep the presentation code out of a stored procedure, and in the application.
与其他任何应用程序一样,存储过程需要一个Connectioncontext。
A stored procedure, like any other application, needs to work off of a Connection context.
使用Web服务接口公开这些存储过程,让更多的应用程序可以使用它们。
The ability to take these stored procedures and expose them using a Web services interface makes it accessible to the larger application infrastructure.
用存储过程调用替代应用程序代码。
可以在ServerExplorer中选择一个表、视图或存储过程来创建XAML应用程序。
A table, view, or stored procedure can be selected in Server Explorer to create an XAML application.
使用存储过程构建应用程序。
如果您需要更改规则,那么只要在存储过程中更改一次,而不需要在调用该存储过程的每个应用程序中都进行更改。
If you need to change the rules, you only need to make the change once in the stored procedure, not in every application that calls the stored procedure.
为了各个应用程序的代码部署,需要专门为每个应用程序创建批文件和存储过程。
The batch files and stored procedures need to be created specifically for each of the application for their respective code deployment.
但更重要的是,阵列是在应用程序和存储过程之间或在存储过程之间流动的数据集合的非常方便的表示形式。
But more importantly, arrays are a very convenient representation for collections of data that flow between an application and stored procedures or between stored procedures.
当创建访问DB2数据的应用程序时,可以通过合并注册到数据库服务器的存储过程和UDF 来改进应用程序的性能。
When you create an application that accesses DB2 data, you can improve your application's performance by incorporating stored procedures and UDFs that are registered with the database server.
想要执行某个事务(例如更新订单或者购买某个产品)的应用程序,只需从应用程序中调用存储过程。
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.
客户机应用程序调用存储过程,然后存储过程执行数据库访问,但不会跨网络返回不必要的数据。
A client application calls the stored procedure, which then performs the database accessing without returning unnecessary data across the network.
应用推荐