Comment
New Contributor II

SergeRielau:  

Not DB2, but the use case is the similar. There are hundreds of legacy views which all reference CURRENT_DATE or CURRENT_DATE - 1 for reporting.  In our non-production environments the data is only current as of the last snapshot that got loaded, which could have been many days past.  The Views are directly connected to a variety of reporting tools.  (Tableau, SSRS etc.)   Without changing code between Dev and Production (as that nullifies audit) need to be able to test views against old date in non-production and current data once things get promoted.