当然,该存储过程的调用者还可以进一步扩展它的执行。
Of course, it is possible to allow the caller of the stored procedure to further control the execution.
要想完成参数的传递及存储过程的调用,必须要做最后一个调整。
For parameter passing and stored procedure invocation you have to make a final adjustment.
RETURN:将一个整数值和控制流返回给存储过程的调用方。
RETURN: Returns an integer and the flow of control to the caller of the stored procedure.
对这个存储过程的调用接受两个运行时参数,customerid和保险XML。
The call to the stored procedure takes in two runtime parameters, the customerid and the insurance XML.
可是,几乎所有存储过程的调用都是同一个模式,主要区别就在于创建的每个参数类型、值等不一样。
However, calling a stored procedures are almost the same, the main difference is the difference between parameters' type or value etc.
它们通常包含参数,并调用一个由所需值填充的参数所组成的存储过程,然后执行一个对存储过程的调用。
They often contain parameters, and calling a stored procedure consists of filling the parameters with the required values and then executing a CALL to the stored procedure.
对于从长期运行的过程发出的同步调用,不支持存储和转发。
Store and Forward is not supported for synchronous calls from long running processes.
您还可以直接从esql调用外部存储的过程,并根据需要处理结果集。
You can also directly call external stored procedures from ESQL, and handle result sets as necessary.
不过,创建模型的调用是一个不具有任何返回值的存储过程。
The call that creates a model is, however, a stored procedure that does not have any return value.
使用默认连接时,存储过程从调用者那里获得它的连接属性。
The stored procedure, when using the default connection, will get its connection properties passed from the caller.
在这个存储过程的末尾,可以通过调用DB 2 . CLOSE_LOG来关闭日志。
At the end of your stored procedure, you can close logging by calling DB2.CLOSE_LOG.
调用存储过程时的SQL 1042。
该向导可以用于定义直接执行SQL或调用存储过程的命令。
The wizard can be used to define commands that execute direct SQL or commands that call stored procedures.
调用不返回结果集的联邦存储过程。
除了其他格式外,StoredProcedureResult返回类型可以方便地封装存储过程调用的结果。
And among others, a StoredProcedureResult return type conveniently encapsulates the results of a stored procedure call.
调用返回结果集的联邦存储过程。
正如您可能已经注意到的那样,Content往往与它们所调用的存储过程具有一对一对应关系。
As you may have noticed, the Content classes tend to have a one-to-one correspondence with the stored procedures that they call.
如果您需要更改规则,那么只要在存储过程中更改一次,而不需要在调用该存储过程的每个应用程序中都进行更改。
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.
注意:该消息是在调用存储过程时写入的,而不是在COMMIT时写入。
Note: This message is written when the stored procedure is invoked, not at COMMIT time.
这种方法的机制是基于用 C实现的存储过程。每个API调用被封装在一个专用的过程中。
The mechanism is based on stored procedures that are implemented in C. Each API call is encapsulated in a dedicated procedure.
调用存储过程的应用程序将在调用过程之前建立这个连接。
The application invoking the stored procedure will establish the connection prior to invoking the procedure.
这包括使用传统更新方法的现有程序和能够利用存储过程调用的外部接口。
This includes existing programs using traditional update methods and external interfaces capable of utilizing stored procedure calls.
JDBC客户机或者直接调用远程存储过程,或者使用相应的联邦存储过程。
The JDBC client called the remote stored procedure either directly or using a corresponding federated stored procedure.
更新过程可以是一个调用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.
包装器存储过程仅仅调用现有的存储过程,并将所包装存储过程的OUT和INOUT参数作为包装器存储过程的结果集返回。
The wrapper stored procedure simply calls the existing stored procedure and returns the OUT and INOUT parameters from the wrapped stored procedure as a result set in the wrapper stored procedure.
这个变量指定防护例程调用(比如存储过程或用户定义函数调用)所使用的池的大小(以4KB页为单位)。
This variable specifies the size (in 4 KB pages) of the pool used for fenced routine invocations, such as stored procedure or user-defined function calls.
在开发存储过程时,强烈建议将这个参数设置为NO,这样,调用存储过程时总会得到全新的存储过程副本。
It is highly recommended that this parameter be set to NO when developing stored procedures, so that a developer will always get a fresh copy of the stored procedure when invoked.
也就是说,所有数据库访问都是通过存储过程调用来执行的。
That is, all database access is performed through stored procedure invocations.
该过程总结收集到的跟踪,并列出调用给定存储过程的频率,以及所有调用总共花费的时间。
This procedure sums up the collected trace and lists how often a given stored procedure was called and how much time passed for all calls.
这可以针对批处理、CICS、COBOL(或PL/1)、DB2存储过程、调试调用的子例程等进行执行。
This can be done for batch, CICS, COBOL or PL/1, DB2 stored procedures, debug-called subroutines, and so on.
应用推荐