Hash File Name - job parameter
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am
Hash File Name - job parameter
Hi All,
I have created a hash file in one job which contains one row and one column.
This value needs to be used in the next job. Kindly let me know how do I use this hash file data in the next jobs.
Can I pass the hash file as a parameter and use the data in that?
This is a very urgent requirement which needs to be moved to production.
Anticipating your help and many thanks for all that in advance.
Regards,
Narry.
I have created a hash file in one job which contains one row and one column.
This value needs to be used in the next job. Kindly let me know how do I use this hash file data in the next jobs.
Can I pass the hash file as a parameter and use the data in that?
This is a very urgent requirement which needs to be moved to production.
Anticipating your help and many thanks for all that in advance.
Regards,
Narry.
Re: Hash File Name - job parameter
A piece of advice buddy, that statement will not guarantee a quicker reply. It just rubs the posters the wrong way, as this is an all-volunteer site.narayana_382 wrote: This is a very urgent requirement
As per your requirement, you said you have just one column right?
So that means this is the key too, which doesnt make sense. You need to provide the key to read the value, if you have just one column, how is that going to work? You are providing a value as a key to read the same value
![Confused :?](./images/smilies/icon_confused.gif)
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am
Apologise for that statement Guru.
But I couldnt figure it out whether to create a hash file/sequential file and use the same file data for the next job.
kindly advise as to how should I proceed in using that one column and one row data in the next job transformer to populate in one of the column derivations.
Please help me...in this regard
Thanks,
Narry.
But I couldnt figure it out whether to create a hash file/sequential file and use the same file data for the next job.
kindly advise as to how should I proceed in using that one column and one row data in the next job transformer to populate in one of the column derivations.
Please help me...in this regard
Thanks,
Narry.
Well you can populate the hashed file with another column defined as key with a dummy value say 'x'.
Do a lookup in your second transformer with the key value hardcoded to the value you specified while building the hashed file, in this case 'x'. Get the second column from the hashed file which is what you want. Thats it.
You can also use USER STATUS and COMMON variables. But i dont want to confuse you more.
Do a lookup in your second transformer with the key value hardcoded to the value you specified while building the hashed file, in this case 'x'. Get the second column from the hashed file which is what you want. Thats it.
You can also use USER STATUS and COMMON variables. But i dont want to confuse you more.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
There are many ways to get your results
If it is just one value.
I would read the value into the UserStatus of the job using DSSetUserStatus.
Then use the .$UserStatus value in the subsequent jobs in a Job Sequence
If it is just one value.
I would read the value into the UserStatus of the job using DSSetUserStatus.
Then use the .$UserStatus value in the subsequent jobs in a Job Sequence
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Premium Member
- Posts: 37
- Joined: Wed Mar 23, 2005 5:20 am