IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

Checksum Usage

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
pjugali



Joined: 01 Jul 2008
Posts: 2
Location: bangalore
Posted: Wed Jul 02, 2008 5:41 pm    Post subject: Checksum Usage  
I got to know that there is checksum attribute which is used to keep track of changes to DB2 tables. Can anyone suggest how to use this checksum in cobol program to get the rows that got changed after during database updated.
Back to top  
nabarundas



Joined: 21 Jun 2007
Posts: 27
Location: pune
Posted: Thu Jul 03, 2008 2:04 pm    Post subject:  
Hi pjugali,

Though I am not completely sure about the checksum attribute but what I know is that it is a connection attribute. I don't think we could be able to use checksum in COBOl program.

My suggestion is if you want to track the database update you can write one trigger that would insert data in seperate table of the updated rows.

If anyone knows more about checksum please give some link.


Regards,
Nabarun
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM