Comment
07-21-2025
12:56 PM
07-21-2025
12:56 PM
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.