Evaluate

Tracking row changes in DB2 tables

ISeries database expert Kent Milligan discusses how to track changes made to DB2 tables.

Kent Milligan, IBM

Published: 02 Apr 2008

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Is there a way to determine when a row in a table on iSeries has been added or changed? Currently there is no user field tracking this. I'm looking for some hidden DB2 function, like the RRN.

Activating journaling for this table would allow easy tracking of row changes. If an adding a new column is an option, you can add a column with the ROWID data type. DB2 will update this value each time a row is added or updated. In V6R1, DB2 for i5/OS supports the creation of a hidden timestamp column just for this purpose.

Shredding XML docs into relational tables with annotated XML schemas

How to shred XML with the DB2 XMLTABLE function

Quiz: Unleashing the Power of the Database

IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 5

Please create a username to comment.

IBM cloud revenues climb as hardware continues to decline

Figure out the differences of asset management vs. CMDB

IBM partners with HBCUs to promote quantum computing

Dig Deeper on DB2 UDB (universal databases)

Shredding XML docs into relational tables with annotated XML schemas

How to shred XML with the DB2 XMLTABLE function

Quiz: Unleashing the Power of the Database

IBM DB2 9 Fundamentals certification (Exam 730): Sample questions about tables, Part 5

Related Q&A from Kent Milligan

Creating a host variable of the 'where in' statement in SQL

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.

SearchDataCenter

IBM cloud revenues climb as hardware continues to decline

Figure out the differences of asset management vs. CMDB

IBM partners with HBCUs to promote quantum computing