hash file

[satya99]

Hi,

How to find out which job is creating a particular hash file?

Thanks.

[DSguru2B]

I found the following sql in one of the archives. Enjoy

Code: Select all

SELECT DS_JOBS.NAME AS JOB_NAME FMT '30L'
FROM DS_JOBS, DS_JOBOBJECTS
WHERE
DS_JOBOBJECTS.OLETYPE = 'CHashedInput' AND
DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO AND
EVAL DS_JOBOBJECTS."@RECORD<6>" = 'Your Hashed File Name'
GROUP BY JOB_NAME;

Run the code from uv prompt from your unix prompt after logging into your project using LOGTO <<ProjectName>> or from DataStage Administrator.