MVSFORUMS.com

Pknair · Beginner Joined: 29 Nov 2005 Posts: 26 Topics: 9

I tried by including the ROWSET statement in the DECLARE CURSOR, but it gave me a -104 at the DECLARE statement itself.

I then used C51 but it keeps giving the -104 error on the FETCH statement

If you get any other thoughts please post it. Meanwhile I ask about NIC's question.

jsharon1248 · Posted: Mon Oct 29, 2007 10:45 am Post subject:

Sorry, no more ideas from me. You'll need to follow up with Nic's suggestion. I saw that the step during the v8 install/upgrade to BIND the packages for REXX is an optional step, so that might be a good starting point for a conversation with your DBA's.

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnigj16/2.7.25?DT=20070805205446

Please be sure to post the solution when you resolve this.

jim haire · Beginner Joined: 30 Dec 2002 Posts: 140 Topics: 40

I see that I am about a month late into this conversation and have not been checking these boards very often.

In a class I took, IBM said that REXX has not been changed to take advantage of DB2 version 8 features such as multi-row fetch and ROWSET positioning. Sad

If someone has been able to take advantage of DB2 version 8 in REXX, I'd be interested in hearing about it.