How to generate a report.

[amolpawar]

HI,

Using a cobol program i am updating some tables, I want to create a report which contains the changes made.

Please help me.


Thanks.
Amol Pawar

[Natarajan]

Please let us know, what exact help you required.

I assume, your question, shold go to DB2 Forum.

[amolpawar]

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.

Please help me,

Thanks,
Amol Pawar

[Anuj Dhawan]

May be writing the details from table to file1 before update and to file2 after update will give you enough information later to create a report.

[amolpawar]

HI,

I am having a cobol program in which one table gets updated.

Query

UPDATE ABC
SET
APP_CDE = '200',
ROW_TM = '%TIMESTAMP%'
UID = '%USER_ID%',
WHERE
BUS_CDE = 200;

This program runs daily with different update queries I want to create a report on the basis of this query.

How to get all the details, what is updated in the table.


Thanks,
Amol

[Natarajan]

if you have only this query.. then it is clear that rows updated where BUS_CDE = 200.. you can write the same in the report.

if you want to write what is the previous state of data base , before updation.. then first use select based on BUS_CDE = 200.. write it to o/p.

do update...

select the records again with BUS_CDE = 200 .. write it to 0/p.

value 200, may change based on input...

[Natarajan]

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.

[dbzTHEdinosauer]

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
update current
loop to fetch