Hi All,
Here is a query to find where SYSDATE is hard coded in all BODS ETL jobs.
SELECT DISTINCT parent_obj
FROM di_repo.al_parent_child,
di_repo.al_langtext
WHERE parent_obj_key=parent_objid
and parent_obj_type<>'DataFlow'
AND parent_obj NOT LIKE 'Copy_%'
AND regexp_count(upper(text_value),'(SYSDATE)')>0;
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.
Thanks,
Abdulrasheed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
9 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |