hash query

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
raju4u
Participant
Posts: 56
Joined: Thu Dec 13, 2007 12:30 am

hash query

Post by raju4u »

Could you please tell me the query..
one hash file is being used by how many jobs in a project.
thanks in advance
\
N R REDDY
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Courtsy is to put an answer if you solved the problem. This will help searchers in future.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
raju4u
Participant
Posts: 56
Joined: Thu Dec 13, 2007 12:30 am

Post by raju4u »

can anybody help us in this regard
N R REDDY
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Nobody answered since the post was marked as "resolved". This is not easy, since hashed files can be utilized by name or by path. If all references are by name or all uses of the hashed file are done by using the same metadata columns then one can search from within the tool. Otherwise a project export to a .dsx or .xml file and subsequent text search of the document might give the best results.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Another possibility is the 'List all files and tables' tool available on Chuck Smith's website. I adapted it to write to a database table so the results can be easily queried.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Mamu Kim
Post Reply