I would like to find all the jobs having a particular field.
Would like to know which internal Datastage Hash file should I search to get the same?
Note: Cannot use Datastage manager for Usage analysis as Metadata management(Table Definitions) are not maintained properly.
Search a Field in Datastage Repository
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
Search a Field in Datastage Repository
Shantanu Choudhary
-
- Charter Member
- Posts: 199
- Joined: Tue Jan 18, 2005 2:50 am
- Location: India
Reporting Tool not equal Usage Analysis. Two different things.
You could also find posts from Chuck Smith and get his free utility that would help in this effort. The URL is www.anotheritco.com from what I recall.
You could also find posts from Chuck Smith and get his free utility that would help in this effort. The URL is www.anotheritco.com from what I recall.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Select the table definition in which the field occurs and perform a usage analysis on it. When a usage analysis is performed on a table definition it reports the columns from that table definition that are actually used in the job. Having performed the usage analysis, go to its File menu and choose View HTML.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.