Searching SQL in BODS

[Former Member]

I want to find every usage of a table in BODS including where it might be used in the free hand SQL transform. Is this possible?

[Former Member · Accepted solution]

You can select the datastore and see the table where it is used. It will show the dataflow. Alternatively you could also see that in the auto documentation feature in management console.

You cannot trace the table used in SQL transform.

[Former Member · Accepted solution]

Is the SQL for the SQL transforms stored in the metadata tables anywhere?

[former_member205887 · Accepted solution]

Hi Tyler,

Check the below metadata tables   al_langtext,  al_langxmltext

[Former Member]

Tyler ,

Check  AL_PARENT_CHILD  table and play with it.

-Harsha