Using BODS Metadata tables to find where SYSDATE is hardcoded
Here is a query to find where SYSDATE is hard coded in all BODS ETL jobs.
SELECT DISTINCT parent_obj
AND parent_obj NOT LIKE ‘Copy_%’
This will help in identifying the jobs having SYSDATE hard coded and can change the code to make it as TABLE driven.
Create a function to call this TABLE and then pass parameters to it get the value and that value can passed to a Global variable in the BODS Script.
As you may know GV can be reused in many places.
Hope this will be helpful.