Skip to Content
Author's profile photo Former Member

Using BODS Metadata tables to find where SYSDATE is hardcoded

Hi All,

Here is a query to find where SYSDATE is hard coded in all BODS ETL jobs.


   FROM di_repo.al_parent_child,


  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.



Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      That's helpful. Thanks