Re: Read all about it - 8 IBM RFE's entered. Vote now!

prodata's DBUJRN command does this.


On Fri, Sep 1, 2017 at 1:36 PM, Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:

On 8/31/2017 2:00 PM, Matt Olson wrote:

Microsoft SQL Server has this. It's called change data capture (CDC), and
exposes the journal data for easy querying.

Say you have a table called IV00101 in SQL Server. Once you activate CDC
on a table a new system view shows up right away that you can query by
doing a "select * from cdc.IV00101" and you will get all the before, after
data in same layout as original table with the extra journal fields at the
beginning. Very powerful, easy to use, and built right into the database
platform. I am hoping DB2 can get there some day.
Is this something new? Extra cost option?

In a former life (maybe 2012/2013) we could have seriously used this to
figure out changes made by the 3rd party folks who ran our website. Someone
found a non-Microsoft product, but boss wasn't interested in the price.

Sam

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD