Hi All,

I am from the solution team, we have a requirement to track the changes(UPDATE & INSERT) in a particular column from different tables. 

Can this be achieved on DB2 Z/os ?? If yes, please advise.

I have been exploring triggers on DB2 but these have some limitations for BEFORE update or INSERT operation done on tables. I need to hold both the new and old values on to my change tracking table so that it will easy to report things on what has been changed and who has changed it.

I would need some suggestions or guide me through how this can be achieved

Regards,
Rakesh MS

Views: 41

Reply to This

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

Register Now IBM Data Tech Summit virtual event October 6th!

Started by Surekha in What's hot ? on Thursday. 0 Replies

Data Tech Summit Virtual Event - The Latest News on Enterprise Data & AIDate:  Tuesday, October 06, 2020Time: 11:00 AM Eastern Daylight TimeRegister NowBusiness cycles are…Continue

Introducing IBM Db2 for z/OS Developer Extension for Microsoft Visual Studio Code

Started by Calene Janacek in Application Development and DB2 Jul 30. 0 Replies

We are excited to announce that the first iteration of IBM Db2 for z/OS Developer Extension is available now as a free downloadable extension in the…Continue

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service