I am having one cobol program which executes some queries ( values hardcoded)
after execution and table updation I want to create a report which contains the query details and what all are the changes that made by query.
If you have latest version of DB2.. you can write one query.. contains.. select... and update.. in this statement.. update will happen to database.. and it will select all updated records. _________________ Natarajan
How to get all the details, what is updated in the table.
what you mean to say is:
how to obtain the before data.
as Natarajan has suggested,
use an update cursor,
FETCH (to obtain before values) - output your details
loop to fetch _________________ Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum