MVSFORUMS.com

edkir98 · Posted: Tue Aug 28, 2007 6:53 am Post subject: Help Reg SQL -508

I am trying to update a particular set of rows in a table using a cursor. It is throwing up SQL -508. Can anyone help?
below is my update statement

dbzTHEdinosauer · Posted: Tue Aug 28, 2007 7:11 am Post subject:

-508 CURSOR not positioned on a row.

The update sql is not your problem. What your program did between the FETCH and the UPDATE is your problem.

Last FETCH SQLCODE = 0?
what did your program do between the FETCH of SJRT-SL-CUR and the UPDATE? and I mean everything.
online or batch?
_________________
Dick Brenholtz
American living in Varel, Germany

kolusu · Posted: Tue Aug 28, 2007 7:15 am Post subject:

edkir98,

The error is self explanatory.

1. Did you define the cursor with "for Update" clause?
2. Were all the updated columns defined in the "for update" clause?
3. Is the cursor open when you are updating ?

Check the explanation of the error -508

edkir98 · Posted: Tue Aug 28, 2007 7:27 am Post subject: re

To dbzTHEdinosauer
I am trying to read from the cursor and process the records and write to output files. Once this is done I check for a particular date field and if the date is same as today then I update the status in a particular column in the table

This is my declare cursor

kolusu · Posted: Tue Aug 28, 2007 7:41 am Post subject:

jsharon1248 · Posted: Tue Aug 28, 2007 8:16 am Post subject:

Are any rows updated? One other remote possibility. I can't tell from the code you displayed, but is the UPDATE in it's own paragraph? I've seen some COBOL programs get lost and 'fall through' paragraphs.

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

edkir98,

Try this:

1. AFter fetching from the cursor, handle the sqlcode -508. (If sqlcode = -508).

2. Display the host variables. These variables will be displayed in the sysout once you run the job.

3. Check the variables against the table.

Let us know your analysis.

Regards,
Vivek G
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

dbzTHEdinosauer · Posted: Tue Aug 28, 2007 9:21 am Post subject:

vivek1983,

you don't receive a -508 from a FETCH.

edkir98 probably does not have an SQLCODE check after his FETCH; he probably received a +100 from his FETCH and attempted to execute the UPDATE WHERE CURRENT CURSOR which gave him the -508.
_________________
Dick Brenholtz
American living in Varel, Germany

edkir98 · Posted: Tue Aug 28, 2007 10:59 am Post subject:

I am getting all the values loaded into the ws variables before the update is executed... Also the fetch from cursor gives sqlcode +100. I'm still helpless..
_________________
Thanks

edkir98 · Posted: Tue Aug 28, 2007 11:00 am Post subject:

I'm sorry..The fetch from the cursor is giveing sqlcode 0
_________________
Thanks

kolusu · Posted: Tue Aug 28, 2007 11:04 am Post subject:

edkir98,

I am sure your code has a fall thru the paragraphs. comment all the code invoking the Update table paragraph and change the code to perform update paragraph like
shown below.

jsharon1248 · Posted: Tue Aug 28, 2007 11:31 am Post subject:

edkri98

You haven't told us if any UPDATEs are successful. If you can reproduce this in a test environment, display the FETCH and UPDATE counts, and the host variables prior to UPDATE. This will help determine if you're falling through paragraphs.

edkir98 · Posted: Tue Aug 28, 2007 11:34 am Post subject:

hi Kolusu,
As you said... its workin fine when I do like this..what could be the problem?

Also I tried another thing.
While update, I put when sqlcode=-508 display 'error ent id ' ent-id.
It displayed only the first ent-id. All others were ok.
There were a total of 318 rows updated except this one. This one alone throws and error
_________________
Thanks

kolusu · Posted: Tue Aug 28, 2007 11:37 am Post subject:

jsharon1248 · Posted: Tue Aug 28, 2007 12:10 pm Post subject:

How do you know that the ENT_ID you displayed is the first one returned by the cursor? I was thinking that you were having a problem trying to UPDATE after a CLOSE, but if what you said about the error occurring on the very first UPDATE is accurate, I'm thinking you might be trying to UPDATE after the OPEN, but before the first FETCH. For 318 rows, I'd do like Kolusu suggested and load it up with DISPLAYs (paragraph names, FETCH and UPDATE counts, host variables), or post it so we can have a look at it.

One more question, are there any DELETEs issued against that cursor?