DB2 Cursors - fetch records and also run another query

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Forum rules
Post Reply Previous topicNext topic
BobP
Registered Member
Posts: 55
Joined: Mon Jun 17, 2013 1:33 pm

DB2 Cursors - fetch records and also run another query

Post by BobP »

Hi,Is it possible to fetch records and also run another query on the same table? If so, can I still retrieve the records without losing any data?
Thanks,
Top
User avatar
zum13
Active Member
Posts: 135
Joined: Thu May 04, 2023 12:58 am

Re: DB2 Cursors - fetch records and also run another query

Post by zum13 »

As far as I'm aware, there's nothing stopping you from doing it. Providing you are retrieving the records into different bits of storage, you shouldn't lose anything.
Top
BobP
Registered Member
Posts: 55
Joined: Mon Jun 17, 2013 1:33 pm

Re: DB2 Cursors - fetch records and also run another query

Post by BobP »

Thanks for the input zum13. Let me work on this. 
Thanks,
Top
Post Reply Previous topicNext topic

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

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”