Processing stops immediately when this statement is executed, and the procedure return code to the caller is the value of SQLERROR.
在执行该语句时处理将立即停止,而过程返回给调用者的代码是SQLERROR的值。
The call that creates a model is, however, a stored procedure that does not have any return value.
不过,创建模型的调用是一个不具有任何返回值的存储过程。
If so, then run the evaluator's internal procedure for that special form and return the result.
如果是,则运行求值程序对应于那个特殊行为的内部处理过程,并返回结果。
Although this procedure is quite simple, it helps you understand how to generate SQL-based procedures that query and return XML data using built-in wizards.
尽管该过程非常简单,但是也能帮助您理解如何使用内置向导生成基于SQL的过程来查询并返回XML数据。
Our experimental setup was the same as for the last tests, except that the remote stored procedure was written to return a result set whose size depended on an input parameter.
实验设置与前面的测试相同,惟一不同的是远程存储过程现在返回一个结果集,结果集的大小取决于输入参数。
When this statement is included in a stored procedure, all return values of executed statements are checked for errors.
当这个语句被包含到一个存储过程中后,将对已执行语句的所有返回值进行错误检查。
If the cursor is closed using the close statement before the return of the SQL procedure, the cursor result set will not be returned to the caller or client application.
如果在返回SQL过程之前使用close语句关闭游标,那么游标结果集就不会返回到调用者或客户机应用程序。
JSON-RPC is a remote procedure call protocol that USES JSON to encode and marshal arguments and return types.
JSON - RPC是一种远程过程调用协议,它使用JSON对参数和返回值进行编码和编组。
Obviously, a stored procedure doesn't have to return a resultset.
显然,存储过程不一定非要返回结果集。
Stored procedure support — You can create and run stored procedures that contain XML data type (input or output) parameters or return XML data.
对存储过程的支持——您可以创建和运行包含XML数据类型(输入或输出)的参数或者返回XML数据的存储过程。
Note: This is the number of parameters of the remote procedure — including REFCURSOR parameters, but not including the return value of functions.
注:这是远程过程的参数数量,包括REFCURS OR参数,但是不包括函数的返回值。
In Listing 24, the procedure proc is coded to return an OUT parameter value, which is denoted by the parameter marker (?), and was not coded to accept an input value.
在清单24中,过程被编码为返回一个OUT参数值,使用参数标记(?)表示,并且不能接受输入值。
In this next example, the string 'hello' is passed into the stored procedure, and when it returns, hello is replaced with the return value of the procedure.
在接下来的例子中,字符串'hello '被传递给存储过程,当存储过程返回时,hello被替换为该存储过程返回的值。
RETURN: Returns an integer and the flow of control to the caller of the stored procedure.
RETURN:将一个整数值和控制流返回给存储过程的调用方。
And among others, a StoredProcedureResult return type conveniently encapsulates the results of a stored procedure call.
除了其他格式外,StoredProcedureResult返回类型可以方便地封装存储过程调用的结果。
The return value from the remote procedure is converted into a standard Perl scalar by call and printed.
远程过程的返回值通过call转换成标准的Perl标量,并打印出来。
You can include none at all if the function is being used as a procedure and has no useful return value.
如果函数被用作一个过程,并且没有任何有用的返回值,那么可以不包含return语句。
Let's first consider how to return the output of the XMLQuery function to variables declared in a stored procedure.
我们首先考虑如何将XMLQuery函数的输出返回给存储过程中声明的变量。
This XPath expression is used with other SQL in the stored procedure to return the sum of the payable amount due on the date supplied as input.
这个XPath表达式与存储过程中的其他SQL相结合,返回在输入的日期应该支付的总金额。
Multiple result sets can be returned from an SQL procedure by using multiple cursors. To return multiple cursors, do the following.
通过使用多个游标,可以从一个SQL过程中返回多个结果集。
There are two statements in the body of the procedure defining a cursor that enables to return table rows. Adapt the first statement declaring the cursor to.
在此过程的主体有两个语句,其作用是定义一个用来返回表行的指针。
The procedure can return null or non-null values.
该过程可以返回null或非null值。
If we were to provide a valid id (such as 10), the stored procedure will return a name (Sanders in that case).
如果提供一个有效的ID(比如10),那么这个存储过程将返回一个名称(在本例中是Sanders)。
DYNAMIC result SETS: This determines if the stored procedure will return a result set or not.
DYNAMICRESULTSETS:这决定存储过程是否返回一个结果集。
If any of the above queries fail to return the desired remote procedure, error SQL1253N is thrown during CREATE procedure.
如果以上任何查询无法返回所需的远程过程,那么在执行CREATEPROCEDURE期间会抛出错误SQL 1253n。
The procedure view allows you to define procedure attribute, parameters, and its properties, the actual SQL body of the stored procedure, as well as the return types for the procedure.
procedure视图允许您定义过程属性、参数及参数属性、存储过程的实际SQL 语句以及过程的返回类型。
The rpgIO data structure is passed to each sub-procedure and the rpgStatus field is used as a return field.
rpgIO数据结构被传递给每个子过程,rpgStatus 字段被用作一个返回字段。
In return, France agreed to support a debt-restructuring procedure demanded by Germany.
作为回报,法国同意支持德国要求的债务重组程序。
When I return to a procedure I forgot that I wrote, I want to see an explanation for what is going on.
这样一来,当我返回一个我很久以前编写的过程时,我就可以查看对它的解释。
It is advised to return on the above procedure again in about 10 minutes to make it more permanent or the congestion could return.
建议10分钟后再按上面程序做一遍,以巩固效果,否则鼻塞流涕可能又会卷土重来。
应用推荐