MVSFORUMS.com

dbzTHEdinosauer · Posted: Tue Aug 28, 2007 1:01 pm Post subject:

What version db2? You should not beable to pre-compile this cursor definition:

UPDATE WITH ORDER BY
_________________
Dick Brenholtz
American living in Varel, Germany

edkir98 · Posted: Tue Aug 28, 2007 1:20 pm Post subject:

Folks I finally got it right..
I removed the WHERE CURRENT OF clause and put WHERE <PRIMARY KEY> = <VALUE>

It works fine.

I was using commit/Restart logic after fetch. may be that caused the cursor to dis-position. I'm not sure though
_________________
Thanks

jsharon1248 · Posted: Tue Aug 28, 2007 2:06 pm Post subject:

edkir98
You eliminated the symptom, but I think the problem is probably still there. I'd double check that restart logic. I'd also be very concerned with commit processing after a FETCH. I would think it belongs wherever your unit of work ends, which would typically be after all INSERT/UPDATE/DELETE processing, not after a FETCH.

dbzTHEdinosaur
Good point about the ORDER BY. That makes the cursor read-only even in V9, so I'm not sure what we've been looking at.

dbzTHEdinosauer · Posted: Tue Aug 28, 2007 2:58 pm Post subject:

edkir98,

Thx for the feedback. Glad everything is alright now.

jsharon1248,

don't ask. you will only get another answer.
_________________
Dick Brenholtz
American living in Varel, Germany