CREATE procedure statement was not issued to define a procedure at the current server.
没有通过发出CREATEPROCEDURE语句在当前服务器上定义过程。
Now the CREATE procedure statement succeeds, and the stored procedure runs successfully.
现在,CREATEprocedure语句成功了,存储过程成功运行。
It also shows how to take advantage of the result set syntax in the CREATE PROCEDURE statement.
还演示如何在CREATEprocedure语句中利用结果集语法。
In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code.
在这个例子中,我们选择修改CREATEprocedure语句而不是修改源代码。
First look at the CREATE procedure statement to confirm what parameters each of the stored procedures expects.
先看一下CREATEPROCEDURE语句,确定每个存储过程所需要的参数。
To avoid this scenario, use the RETURNS clause of the CREATE PROCEDURE statement to return data to the caller.
要避免这种情况,使用CREATEPROCEDURE语句的returns子句来将数据返回给调用者。
These definitions are determined in the CREATE PROCEDURE statement of the federated procedure, not on the data source.
这些定义在联邦过程的CREATEPROCEDURE语句中决定,而不是数据源上。
You may need to change the command delimiter away from the semicolon before entering the CREATE PROCEDURE statement.
在输入CREATEPROCEDURE语句前,您可能需要更改命令分隔符,使其不是分号。
Listing 9 contains a code example of the SQL CREATE procedure statement used to register an RPG program as an external stored procedure.
清单9包含一个用于将一个R PG程序注册为一个外部存储过程的SQLCREATEPROCEDURE语句的代码示例。
In the CREATE procedure statement, you can specify several options for that stored procedure. Here are a few of them that have significance.
在CREATEprocedure语句中,可以为存储过程指定几个选项。
For some browsing applications to parse the CREATE PROCEDURE statement itself, you need the command delimiter to be something other than a semicolon.
对于要分析CREATEPROCEDURE语句本身的某些浏览应用程序而言,需要采用不是分号的其它命令分隔符。
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语句,确保传递的输入和输出参数的数量和数据类型都正确。
And as before, you can fix the problem by re-issuing the correct CREATE PROCEDURE statement. For more information about Java VM type signatures, go to this url.
而且与前面一样,可以通过重新发出正确的CREATEPROCEDURE语句来纠正这个问题。
The CREATE PROCEDURE statement provides special syntax for Oracle routines in packages, a three-part name in the SOURCE clause where the middle part identifies the package.
CREATEprocedure语句为包中的Oracle例程提供了特殊语法,即source子句中分三部分的名称,其中中间的部分标识包。
If two or more data source procedures have identical schema and procedure names, but different Numbers of parameters, then the number of parameters can be specified in the CREATE procedure statement.
如果两个或更多的数据源过程具有相同的模式和过程名,但是参数数量不同,那么可以在CREATEprocedure语句中指定NUMBEROFPARAMETERS。
Triggers Supports before row triggers, after row and statement triggers with trigger statements written in procedure language compound statements.
触发器支持行前触发器、行后触发器和语句触发器,触发器语句用过程语言复合语句编写。
If you have not declared a handler for a condition, DB2 passes control to the next statement in the SQL procedure body.
如果没有为条件声明处理程序,DB 2将把控制器传递到SQL过程体中的下一个语句。
When this statement is included in a stored procedure, all return values of executed statements are checked for errors.
当这个语句被包含到一个存储过程中后,将对已执行语句的所有返回值进行错误检查。
The EXPLAIN_FROM_CATALOG procedure produces explain information about a statement using the content of the section from the catalog tables.
EXPLAIN_FROM_CATALOG过程将使用目录表中的片段内容生成有关一条语句的解释信息。
Processing stops immediately when this statement is executed, and the procedure return code to the caller is the value of SQLERROR.
在执行该语句时处理将立即停止,而过程返回给调用者的代码是SQLERROR的值。
If statement execution returns an error, the procedure is automatically aborted or the transaction is rolled back.
如果语句执行返回一个错误,过程将自动中断或回滚事务。
The statement was executed within the procedure virtual machine (PVM).
该语句在过程虚拟机(PVM)中执行。
The first statement within the stored procedure is a DELETE to remove the existing rows in the local destination table SALES.
存储过程中的第一个语句是DELETE,它删除本地目标表 SALES 中现有的行。
The remote procedure referenced by the federated procedure must not issue a COMMIT or a ROLLBACK statement.
联邦过程所引用的远程过程不能发出COMMIT或rollback语句。
Develop your SQL statement, stored procedure, or XQuery statement.
开发sql语句、存储过程或XQuery语句。
The AccountDetail stored procedure retrieves detailed account statement information for a given account number (see Figure 4).
AccountDetail存储过程获取给定的客户号的详细账户状态信息(见图4)。
DB2Command - The command object allows for executing any supported SQL statement or stored procedure using a data connection object.
DB 2 Command-该命令对象支持使用数据连接对象执行任何受支持的sql语句或存储过程。
A Data Web Service can contain one or more operations where each is based on a single stored procedure call or SQL statement.
每个DataWebService可以包含一个或多个操作,每个操作都是基于一个存储过程调用或一条sql语句。
If you want to trace every statement in your stored procedure, you can turn on proctrace, which traces each statement inside the specified stored procedure.
如果希望在存储过程中跟踪每一条语句,可以启用proctrace,它将跟踪指定存储过程中的每一条语句。
This time, instead of a SELECT statement, we'll use the stored procedure references by the BdpCommand.
这一次我们不再使用select语句,而是通过BdpCommand使用存储过程引用。
应用推荐