View previous topic :: View next topic
|
Author |
Message |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
ramangouda patil wrote: |
Hi All,
Below is snippet form the spool output for couple of cursors. the second and third gave an error of -991 but the first shows 919.
[*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* SQL RETURN CODE: 919 *
* ERROR OPENING CRS3E00 CSR *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* SQL RETURN CODE: 991- *
* ERROR CLOSING CRS3E00 CSR *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
* SQL RETURN CODE: 991- *
* ERROR CLOSING CRS028 CSR *
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* ][/code] |
How do you relate "DECLARE E5100CR CURSOR" to "CRS3E00" in the above message extract?
Since 919 does not exist in DB2, you didn't get a 919 from an SQL statement. This is supported by the SQLSTATE being zero, rather than some value which would aid problem determination.
Did you try Dick Scherrer's suggestion?
If you want anything further here, you're going to have to cough-up relevant unedited code. |
|
Back to top |
|
|
ramangouda patil
New User
Joined: 09 Apr 2008 Posts: 39 Location: India
|
|
|
|
Hello All,
We discarded the cursor approach and went with downloading of table data. The reason was this was a one time run requirement and a download was able to cater the need. Also on the cursor name question, I just changed the name of the cursor while posting it in this forum.The program had the same cursor name in the definition and while opening the cursor.
Thanks for all the help and apologies if I created a whole lot of confusion. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is resolved - thank you for letting us know
d |
|
Back to top |
|
|
|