Is it possible to access the ROW CHANGE TIMESTAMP via Data Migrator? I have a routine that needs to pull all records that have changed recently, but I can't figure out a way to pass the ROW CHANGE concept to DB2 via Data Migrator. It won't even let me click the OK button on the filter routine if I have ROW CHANGE in the text.
J.This message has been edited. Last edited by: <Kathryn Henning>,
May 23, 2013, 12:07 PM
If you have a column in the DB2 source table generated as a ROW CHANGE TIMESTAMP when you create the synonym for it the column is included (as READONLY) and you can use it in a SELECT list or WHERE condition.
For tables without such a column DB2 "returns a timestamp value that reflects changes made to the page instead of to the row." If that's what you want you can access it with an expression like: