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.
如果使用了受防护的存储过程,那么除了运行存储过程应用程序所需的内存之外,每个用户连接还有两个DB 2代理程序。
You can implement this kind of logic in the client application or as a stored procedure.
您可在客户端应用程序中或者作为存储过程来实现此类逻辑。
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.
在本文中,我们演示了如何将DB 2命令封装在存储过程中,使得几乎任何应用程序都可以访问任何DB 2命令。
Large result sets can be processed on the DB2 server within the stored procedure module to reduce the amount of data that must be processed within the client application.
在DB 2服务器上的存储过程模块内可以处理大型的结果集,以减少在客户机应用程序内必须处理的数据量。
A client application can call on the stored procedure to perform a series of native operations in one trip to the database, rather than involving multiple trips to the database server.
客户端应用程序通过调用存储过程只需要访问数据库一次就可以执行一系列本地操作,而不用多次访问数据库服务器。
The use of this stored procedure required only the parameter value and the name of the stored procedure itself to be sent from the client application to the database server.
要使用存储过程,仅需从客户机应用程序向数据库服务器发送参数值和存储过程本身的名称即可。
The application invoking the stored procedure will establish the connection prior to invoking the procedure.
调用存储过程的应用程序将在调用过程之前建立这个连接。
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代码定义并存储在数据库本身中,然后从应用程序中进行调用。
A DB2 CLI application was implemented for each version of the stored procedure.
针对存储过程的每个版本实现一个DB 2CLI应用程序。
A client application calls the stored procedure, which then performs the database accessing without returning unnecessary data across the network.
客户机应用程序调用存储过程,然后存储过程执行数据库访问,但不会跨网络返回不必要的数据。
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.
想要执行某个事务(例如更新订单或者购买某个产品)的应用程序,只需从应用程序中调用存储过程。
Named parameter makes the application robust so that you don't need to change the application even if the sequence of the parameter in the stored procedure changes.
命名参数使应用程序更加健壮,所以,即使存储过程中参数的顺序发生了改变,也不必修改应用程序。
A calling application connected to the federated server cannot distinguish the federated stored procedure from a local stored procedure.
连接到联邦服务器的调用应用程序无法区分联邦存储过程和本地存储过程。
The article also explains the specialties when LOAD FROM CURSOR operations are executed within application code using the ADMIN_CMD stored procedure.
还解释了通过 ADMIN_CMD存储过程在应用程序代码中执行LOADFROMCURSOR操作时的特殊问题。
Many administrative commands can also be embedded in application code by executing the administrative commands through the special stored procedure ADMIN_CMD.
可以通过特殊的存储过程ADMIN_CMD执行许多管理命令,从而把管理命令嵌入在应用程序代码中。
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.
将需要大量工作以使表示代码不在存储过程中,而在应用程序中。
Parameter MARKER: an application may wish to call the same query multiple times, only changing specific values each time (ex: parameters sent to a stored procedure, or a value in a WHERE clause).
参数标志(PARAMETER MARKER):应用程序可能希望多次调用同一个查询,每次调用时只改变特定的值(例如,发送给存储过程的参数,或者where子句中的值)。
Replace the application code with stored procedure call.
用存储过程调用替代应用程序代码。
If the stored procedure includes any OUT parameters, it needs to be invoked from a client application using the CallableStatement interface.
如果存储过程包含OUT参数,那么就需要通过CallableStatement接口,从客户机应用程序调用该参数。
A table, view, or stored procedure can be selected in Server Explorer to create an XAML application.
可以在ServerExplorer中选择一个表、视图或存储过程来创建XAML应用程序。
A stored procedure, like any other application, needs to work off of a Connection context.
与其他任何应用程序一样,存储过程需要一个Connectioncontext。
We've also built a Delphi 2005 WinForms application calling the stored procedure at runtime, again passing parameters and viewing the result in a DataGrid.
我们还构建了一个在运行时调用存储过程的Delphi 2005WinForms应用程序,同样也传递了参数并在一个DataGrid内查看了结果。
Creating a Service Request in a CRM application exposed as a Database stored procedure (e.g. Oracle CRM) exposed over ESB using MQ or JMS bindings; or.
在CRM应用程序中创建服务请求,使用MQ或JMS绑定通过ESB公开为一个数据库存储的过程(如oracle CRM);或者。
Additionally, the application available for download contains the full implementation of the Atom feed, including the stored procedure and the application code to generate the feed.
另外,本文提供的应用程序下载包包含Atom提要的完整实现,包括用来生成feed的存储过程和应用程序代码。
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。
You can install the BankAccountCMPSP application from the download file and run the application client to see how a stored procedure is used.
用户可以从下载文件中安装BankAccountCMPSP应用程序,运行应用程序客户端来查看如何使用存储过程。
As mentioned above, if a stored procedure includes OUT parameters, a client application executes the stored procedure using the CallableStatement method, as shown in Listing 9.
正如上面所提及的,如果存储过程包含OUT参数,那么客户机应用程序就会使用CallableStatement方法来执行该存储过程,如清单9所示。
Only the results the client application needs are returned by the stored procedure. Stored procedures offer these benefits.
存储过程只返回客户机应用程序需要的结果。
The JDBC application returned these as a ResultSet object from either the federated stored procedure or the remote native stored procedure.
JDBC应用程序以ResultSet对象的形式从联邦存储过程或远程本地存储过程返回结果集。
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.
如果您需要更改规则,那么只要在存储过程中更改一次,而不需要在调用该存储过程的每个应用程序中都进行更改。
应用推荐