Page 1 of 1
DB2 Cursors - fetch records and also run another query
Posted: Mon Sep 30, 2024 10:02 am
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?
Re: DB2 Cursors - fetch records and also run another query
Posted: Mon Sep 30, 2024 7:15 pm
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.
Re: DB2 Cursors - fetch records and also run another query
Posted: Thu Oct 03, 2024 10:25 am
by BobP
Thanks for the input zum13. Let me work on this.