SQLCODE -503- need help



IBM's flagship relational database management system

SQLCODE -503- need help

Postby manjujacob13 » Tue Mar 02, 2010 11:24 am

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
manjujacob13
 
Posts: 7
Joined: Fri Feb 26, 2010 9:40 am
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE -503- need help

 

Re: SQLCODE -503- need help

Postby dick scherrer » Tue Mar 02, 2010 11:36 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: SQLCODE -503- need help

Postby manjujacob13 » Tue Mar 02, 2010 11:49 am

Thanks Dick, It works :)

Manju
manjujacob13
 
Posts: 7
Joined: Fri Feb 26, 2010 9:40 am
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE -503- need help

Postby dick scherrer » Tue Mar 02, 2010 11:56 am

Good to hear it is working - thank you for letting us know :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post