Changing SELECT cursor to update cursor.

Dipak Chaurasiya · Post by **Dipak Chaurasiya** » Mon Jan 04, 2016 3:35 pm

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.

Post by **nicc** » Tue Jan 05, 2016 1:34 am

Read about how to declare a cursor for update.

Mainframe, MVS and zOS Discussion

Changing SELECT cursor to update cursor.

Changing SELECT cursor to update cursor.

Re: Changing SELECT cursor to update cursor.

Create an account or sign in to join the discussion

Create an account

Sign in