The following tools are provided on an "as-is" basis without warranty of any kind. Please refer to the agreement in each tool for complete details.
The following tools were developed using Universe Basic for pre-version 6 DataStage. They must be copied to, compiled, and run on your DataStage server. If you are unsure how to do this, send me an email, and I will try to help.
List hash files used by all jobs in a project.
RUN BP LIST_HASH
3 record(s) selected to SELECT list #2.
Job: FirstJobName
Stage: YourStageName Link Name: YourLinkName
Hash File Name: YourHashFileName
Column1Name,Column2Name
Job: SecondJobName
Stage: StageName Link Name: YourLinkName
Hash File Name: YourHashFileName
Column1Name,Column2Name
Job: ThirdJobName <== This job has no hash files.
RUN BP LIST_OCI
3 record(s) selected to SELECT list #2.
Job: FirstJobName
Stage: YourStageName Link Name: YourLinkName
Hash File Name: YourHashFileName
Column1Name,Column2Name
Job: SecondJobName
Stage: StageName Link Name: YourLinkName
Hash File Name: YourHashFileName
Column1Name,Column2Name
Job: ThirdJobName <== This job has no hash files.
RUN BP LIST_ODBC
3 record(s) selected to SELECT list #2.
Job: FirstJobName
Stage: YourStageName Link Name: YourLinkName
Hash File Name: YourHashFileName
Column1Name,Column2Name
Job: SecondJobName
Stage: StageName Link Name: YourLinkName
Hash File Name: YourHashFileName
Column1Name,Column2Name
Job: ThirdJobName <== This job has no hash files.
RUN BP LIST_PARAMETERS
2 record(s) selected to SELECT list #0.
Processing job: FirstJobName
Processing job number: 1
Job1Parameter1Name
Processing job: SecondJobName
Processing job number: 2
Job2Parameter1Name
Job2Parameter2Name
RUN BP SEARCH_HASH Enter table name to search for: YourTableName 5000 record(s) selected to SELECT list #2. Job: FirstJobNameThatUsesYourTable Job: SecondJobNameThatUsesYourTable Job: ThirdJobNameThatUsesYourTable Done.
RUN BP SEARCH_OCI Enter table name to search for: YourTableName 5000 record(s) selected to SELECT list #2. Job: FirstJobNameThatUsesYourTable Job: SecondJobNameThatUsesYourTable Job: ThirdJobNameThatUsesYourTable Done.
RUN BP SEARCH_ODBC Enter table name to search for: YourTableName 5000 record(s) selected to SELECT list #2. Job: FirstJobNameThatUsesYourTable Job: SecondJobNameThatUsesYourTable Job: ThirdJobNameThatUsesYourTable Done.