A BLOB variable is declared for the procedure output parameter.
将过程输出参数声明为blob变量。
Please note that this procedure has one input and one output parameter.
请注意,这个存储过程有一个输入参数和一个输出参数。
Listing 20 creates a procedure that has two input parameters and two results set column names for output rows.
清单20创建的过程为输出行提供了两个输入参数和两个结果集列名。
Solution: Check the CREATE PROCEDURE statement and make sure you are passing the correct number of input and output parameters with proper data types.
解决方案:检查CREATEPROCEDURE语句,确保传递的输入和输出参数的数量和数据类型都正确。
Private tokens — an individual stored procedure or a group of stored procedures can have a token name that signals that output logging is required for this token.
私有标记——单个存储过程或一组存储过程可以采用某个标记名,来说明这个标记需要输出日志。
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数据的存储过程。
In the output from calling the stored procedure, you can see the difference between extracting an XML element, and extracting the value of an XML element.
在调用存储过程的输出中,可以看到提取xml元素与提取XML元素值之间的差异。
Notice that the console output (Listing 7) displays the same output as the stored procedure call from the JDBC program as shown in Figure 2.
注意操控台输出(代码行7)显示了与访问图2所示jdbc程序存储过程相同的输出。
The last five arguments of this stored procedure are output parameters.
这个存储过程的最后5个参数是输出参数。
For stored procedures, you can map the input and output parameters of the stored procedure to the data set source columns as defined in the select command.
对于存储过程,您可以将该存储过程的的输入和输出参数映射到select命令中所定义的数据集源列。
Click OK, and view the results of your stored procedure in the Data Output pane.
单击ok,并在Data Output窗格中查看存储过程的结果。
The next code sample describes how to make use of the StoredProcedureResult object type to access all the output information of a stored procedure call.
下面的代码示例描述如何使用StoredProcedureResult对象类型访问一个存储过程调用的所有输出信息?
The Data Output pane in the lower right corner should note that your procedure has been successfully deployed.
右下角的Data Output窗格应该指出过程已经成功部署。
By using the StoredProcedureResult object, you avoid the need to register output parameters before calling the stored procedure.
通过使用StoredProcedureResult对象,可以不必在调用存储过程之前注册输出参数。
In order to access all the information returned by a stored procedure call, developers need to register all the output parameters beforehand and assign the result of the call to a ResultSet object.
为了访问存储过程调用返回的所有信息,开发人员需要预先注册所有的输出参数,并将调用的结果赋给一个ResultSet对象。
Let's first consider how to return the output of the XMLQuery function to variables declared in a stored procedure.
我们首先考虑如何将XMLQuery函数的输出返回给存储过程中声明的变量。
Sybase existing tables can be used with a WHERE clause specifying column names of the existing table to restrict the output received from the stored procedure.
对于Sybase现有表,可以使用where子句指定现有表的列名,以限制存储过程的输出。
A developer that creates a CMP bean that USES a stored procedure knows how to invoke this stored procedure and handle the input and output parameters.
创建过使用存储过程的CMPbean的开发人员知道如何调用这个存储过程,以及如何处理输入和输出参数。
The com.ibm.websphere.sample.BankAccountSPFile file contains the logic that handles the input/output parameter and invocation of the stored procedure.
BankAccountSPFile文件包含处理输入/输出参数和调用存储过程的逻辑。
DB2 V8.2.2 also enhances the output of the get_db_config stored procedure.
db 2V8.2.2还增强了get_db_config存储过程的输出。
The table UBLADMIN.CUSTOMER in the supplied DDL matches the format of the output from this stored procedure.
提供的DDL中的UBLADMIN . customer表与这个存储过程的输出格式匹配。
As of DB2 V8.2.2, all of the missing parameters have been added to the output of the get_db_config stored procedure.
从db 2V8.2.2开始,向get_db_config存储过程的输出添加了所有遗漏的参数。
The SALES_STATUS procedure accepts an input parameter called quota and returns an output parameter called sql_state.
SALES_STATUS过程接受名为quota的输入参数,并返回名为sql_state的输出参数。
Although you can listen to the recording, the output from this procedure can be improved. For example.
尽管可以听录音带了,但是该过程的结果还是可以改善的。
Listing 8 shows a CALL statement issued from the CLP to the procedure find_customers defined earlier, and the output generated by the CLP.
清单8显示了从CLP向前面定义的过程find _ customers发出的call语句以及clp生成的输出。
In mathematical programming, the goal of coding is often the standard output values that the analytical procedure (such as MultipleRegression, TimeSeries, or ChiSquared) is expected to generate.
在数学编程中,编码的目标通常是分析过程(比如MultipleRegression、TimeSeries或ChiS qu ared)所希望生成的标准输出值。
Listing 17 shows an example of a CALL statement issued from the CLP to procedure alternate_find_customers and the output generated by the CLP.
清单17显示了从CLP向过程alternate_find _ customers发出的call语句的示例以及clp生成的输出。
The new table functions are created after the procedure executes. To list the output columns for the table functions, execute the following statements
在执行该过程后创建新的表函数。
It then constructs the SQL file using the data, protecting the data types and then writing into the output file using Izuha's file writing utility. Here is the signature of the procedure.
然后用这些数据构造SQL文件,保护数据类型,并使用Izuha的文件编写工具写入输出文件。
Cache appropriate data such as relatively static Web pages, specific items of output data, stored procedure parameters, and query results.
缓存适当的数据,如相对静态的网页,明确的输出数据的条目,存储过程参数和查询结果集等。
应用推荐