问题描述
你好......
我正在尝试创建一个接收两个参数的存储过程（都是Date）。 SP必须从包含两个JOIN的两个JOIN和三个WHERE条件的Select创建一个View。
我在Windows 7 32位和IBM Data上使用DB2 9.7 FixPack 2 Studio 2.2。
我遇到的问题是，通过部署SP会返回以下错误：
COBR.SP_CREATEVIEWMOVCUSTOMER ：17：STARTDATEMONITOR在上下文中无效..使用它的位置SQLCODE = - 206，SQLSTATE = 42703，DRIVER = 3.61.65
我的SP的代码如下：
Hello ...
I''m trying to create a Stored Procedure that receives two parameters (both are Date). The SP must create a View from a Select containing two JOIN and three WHERE conditions involving the two parameters.
I am working with DB2 9.7 FixPack 2 on Windows 7 32-bit and IBM Data Studio 2.2.
The problem I have is that by making the deployment of the SP returns the following error:
COBR.SP_CREATEVIEWMOVCUSTOMER: 17: "STARTDATEMONITOR" is not valid in the context .. Where It is Used SQLCODE =- 206, SQLSTATE = 42703, DRIVER = 3.61.65
The code of my SP is as follows:
推荐答案
这篇关于创建视图中带参数的DB2存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！