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.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply