Job search query
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Wed Mar 24, 2004 1:28 am
Job search query
Hi,
How I will find out those jobs names, which are using given column name. Suppose column name is Satus then which jobs are using this column.
Regards
Vikas Gupta
How I will find out those jobs names, which are using given column name. Suppose column name is Satus then which jobs are using this column.
Regards
Vikas Gupta
Hi,
search this forum some code was givven to query Ds repository in hte past that might answer your need.
by the way although it might not be 100% what you need you could try using the usage analysis from DS maanger to try find all jobs using a specific table definition (but it is not a search by column name used in jobs)
IHTH,
search this forum some code was givven to query Ds repository in hte past that might answer your need.
by the way although it might not be 100% what you need you could try using the usage analysis from DS maanger to try find all jobs using a specific table definition (but it is not a search by column name used in jobs)
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 82
- Joined: Thu Dec 02, 2004 10:27 pm
- Location: INDIA
Hello Vikas,
In addition to what has already been suggested, you can use the reporting assistant in the manager for a detailed analysis, or even right-click on the table name (again in the manager) to get a usage report, that will tell you which job use the metadata from that table - this method works only if the column name wasn't manually entered in a design.
You can also do a full project export in either .dsx or .xml format and search within those text files for occurrences of your columns of interest; this doesn't really work well if your column name is something like "a" .
In addition to what has already been suggested, you can use the reporting assistant in the manager for a detailed analysis, or even right-click on the table name (again in the manager) to get a usage report, that will tell you which job use the metadata from that table - this method works only if the column name wasn't manually entered in a design.
You can also do a full project export in either .dsx or .xml format and search within those text files for occurrences of your columns of interest; this doesn't really work well if your column name is something like "a" .
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I think I've replied to a similar question before and it has been discussed a lot in this forus. Export out as XML, parse it by some XSL parser or any Javadoc kind of utility. Its very flexible this way.
- Sachin
- Sachin
ArndW wrote:Hello Vikas,
In addition to what has already been suggested, you can use the reporting assistant in the manager for a detailed analysis, or even right-click on the table name (again in the manager) to get a usage report, that will tell you which job use the metadata from that table - this method works only if the column name wasn't manually entered in a design.
You can also do a full project export in either .dsx or .xml format and search within those text files for occurrences of your columns of interest; this doesn't really work well if your column name is something like "a" .
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
You can use my Search a dsx file for a sting tool. Export your job designs, then copy the dsx file to your DataStage server. Run the tool, giving the dsx file name and column name as parameter values. The tool will give you a list of categories and jobs that include the string (your column name).
You may find the tool on the DataStage Tools page of www.anotheritco.com.
You may find the tool on the DataStage Tools page of www.anotheritco.com.
Chuck Smith
www.anotheritco.com
www.anotheritco.com
The person indicating the use of MetaStage is right on....This will allow you to perform an impactanalysis of where columns are used in what Projects and what Jobs. In addition if you use the specific MetaBrokers to your situation (e.g,, ERwin, Business Objects, Cognos, and so on) then you can know the columns not only in DataStage Jobs but what Business Objects, for example, reports use these columns.