View previous topic :: View next topic
|
Author |
Message |
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Hi,
I am getting a -818 error while opening a cursor. I have used
parameter in the cursor declaration. Please help me solve this.
Code: |
DECLARE TAB1_CSR CURSOR
WITH ROWSET POSITIONING FOR
SELECT A.ATTR1
,A.ATTR2
,A.ATTR3
FROM TABLE1 A
,TABLE2 B
,TABLE3 C
WHERE C.COL1=:VAR1 AND
C.COL2=:VAR2 AND
B.COL3=:VAR3
|
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
Back to top |
|
|
sri_mf
Active User
Joined: 31 Aug 2006 Posts: 218 Location: India
|
|
|
|
Bind the program and then execute it.
When ever u make any changes to tehe COBOL-DB2 Program u have to Bind it first and then Run it.
Correct me if i am wrong. |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Thanks very much guys, I resolved it.
Quote: |
When ever u make any changes to tehe COBOL-DB2 Program u have to Bind it first and then Run it.
|
I bound it everytime I made changes. But the changes were not getting reflected since it was a subroutine. I had to compile the program which is calling this subroutine everytime I made changes. I wanted to know if there are other possibilities which give a -818. |
|
Back to top |
|
|
|