Changing SELECT cursor to update cursor.
-
- New Member
- Posts: 1
- Joined: Wed Dec 23, 2015 12:06 pm
Changing SELECT cursor to update cursor.
We have a program which is COBOL-DB2 batch program. This program is using only SELECT SQL queries. Now, for a new requirement this program needs to update the tables also. From the same cursor I would like to update some of the records that I have fetched from that cursor. Can I do update at the same time as processing the cursor? If I can do that, can you please help out.
Re: Changing SELECT cursor to update cursor.
Read about how to declare a cursor for update.
Regards
Nic
Nic
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute