find datastage jobs in project using field name
Moderators: chulett, rschirm, roy
find datastage jobs in project using field name
Hi All,
I have to do some amendment in a field which is being used by datastage jobs in a project. I have 1000s of datastage jobs in my project. I need to findout the impected datastage jobs which are using that fields.
Can any one please let me know if we have any utility/ program by which we can do this.
Thanks in Advance.
Deepak
I have to do some amendment in a field which is being used by datastage jobs in a project. I have 1000s of datastage jobs in my project. I need to findout the impected datastage jobs which are using that fields.
Can any one please let me know if we have any utility/ program by which we can do this.
Thanks in Advance.
Deepak
Thanks Craig,
I think, The first option of Usage Analysis doesn't give the informaiton about the field/metadata.
I am trying the second option, but it is taking lot of time and it manual work which currently i am doing.
Please let me know if you have come accross this type of problem before and how did you workout.
Thanks
Deepak
I think, The first option of Usage Analysis doesn't give the informaiton about the field/metadata.
I am trying the second option, but it is taking lot of time and it manual work which currently i am doing.
Please let me know if you have come accross this type of problem before and how did you workout.
Thanks
Deepak
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
If you have stored your table meta data in the repository and loaded it into the job then the first option does exactly what you need. Otherwise, you've got no other option but a search of the dsx. Well, except for things like Chuck Smith as written, he has a utility to parse a dsx and I've modified it in the past to load the results to a database table so they become query-able.
Check out his website at: www.anotheritco.com
Check out his website at: www.anotheritco.com
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Metadata Workbench can provide you with this information also, by doing a query that looks at "Stage Columns"....which are effectively, Columns-on-a-link.....
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
I think you can tweak the below query running in Universe tables for your need.
SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY , DS_JOBOBJECTS.NAME AS OBJECT_NAME , DS_JOBOBJECTS.OLETYPE , EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOUR_FIELD_NAME',1) > 0 then 'FOUND' else ''" AS RECORD , EVAL DS_JOBOBJECTS."@RECORD<8>" AS OBJ_TYPE FMT '50L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND RECORD='FOUND';
Same SQL will be used the find the list of jobs using a particular table.
SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY , DS_JOBOBJECTS.NAME AS OBJECT_NAME , DS_JOBOBJECTS.OLETYPE , EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOUR_FIELD_NAME',1) > 0 then 'FOUND' else ''" AS RECORD , EVAL DS_JOBOBJECTS."@RECORD<8>" AS OBJ_TYPE FMT '50L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO AND RECORD='FOUND';
Same SQL will be used the find the list of jobs using a particular table.
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
And to Craig's point, Workbench isn't available in 7.x, but you could import 7.x Jobs into 8.x with Workbench and immediately analyze them (meaning, they don't have to be compiled and running in v8, just imported).
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>