Joined: 10 Dec 2010 Posts: 96 Location: Massachusetts
I spoke with the DBA's on this and got an 'i don't think so'. We are running trial conversions for different months going back from today and the DB2 tables we are using are getting 'refreshed' with PROD data for a fixed day. I thought maybe we could query off of sys1dummy to get the date that new data was loaded in. I do not think we are dropping the table so maybe this approach is a no go. We would like to use that date to get 3 years back worth of some payment history.
No rush and thanks.