Page 1 of 1

SQLCODE -503- need help

PostPosted: Tue Mar 02, 2010 11:24 am
by manjujacob13
Hi,

I am getting Sqlcode -503, while i am trying to bind my cobol-Db2 program. I am using cursor to update the record. can anyone please help to solve this. please explain me the steps to update records using cursor in cobol.

Thanks in advance,
Manju

Re: SQLCODE -503- need help

PostPosted: Tue Mar 02, 2010 11:36 am
by dick scherrer
Hello,

I suspect you are trying to update a column that was not specified in the update clause. . .

Look here:
http://publibz.boulder.ibm.com/cgi-bin/ ... /2.1.6.214

Declare the cursor
Open the cursor
Fetch the rows
Update as needed.

Re: SQLCODE -503- need help

PostPosted: Tue Mar 02, 2010 11:49 am
by manjujacob13
Thanks Dick, It works :)

Manju

Re: SQLCODE -503- need help

PostPosted: Tue Mar 02, 2010 11:56 am
by dick scherrer
Good to hear it is working - thank you for letting us know :)

d