Job Parametr and Hash Fiel name
Moderators: chulett, rschirm, roy
Job Parametr and Hash Fiel name
I do lookup from Hash file . I want to run job some times with different hash files therefore I defined Job parametr for it.
How to incoporate the Job parametr into hash file name in hash file stage ?
Filename :File1 where 1 is Job parametr
How to incoporate the Job parametr into hash file name in hash file stage ?
Filename :File1 where 1 is Job parametr
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your approach only works if the hashed files have identical metadata in terms of how data are stored in them.
DataStage is absolutely metadata driven. If you need different metadata (table definition) then you need a new job design.
DataStage is absolutely metadata driven. If you need different metadata (table definition) then you need a new job design.
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.
Is "NUMBER" your parameter - remember that parameters are case sensitive.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
snassimr,
in the Designer, if you do a "View Data" on the hash file do you get prompted to fill in the value of the parameter?
in the Designer, if you do a "View Data" on the hash file do you get prompted to fill in the value of the parameter?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
greate hash file before look up
one possbile reason is that you look up hash file before the file is crreated.Sainath.Srinivasan wrote:You have not defined that parameter in your job.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DSD.UVOpen Unable to open file Hash#NUMBER#.
The fact that a job parameter reference appears in the error message means that the job parameter has not been resolved.
Try a View Data on the Hashed File stage output link. Does this parameter get prompted for? If not, it means either that the job parameter is not defined in this job at all, or that it is not spelled or cased the same way in the job parameter definitions and in the Hashed File stage output link's File Name field.
Without wishing to be rude, your assertion that "Yes . Its the exactly name of my parametr" seems not to be the case; your typing skills as seen in this thread add to our suspicions that my diagnosis will be close.
The fact that a job parameter reference appears in the error message means that the job parameter has not been resolved.
Try a View Data on the Hashed File stage output link. Does this parameter get prompted for? If not, it means either that the job parameter is not defined in this job at all, or that it is not spelled or cased the same way in the job parameter definitions and in the Hashed File stage output link's File Name field.
Without wishing to be rude, your assertion that "Yes . Its the exactly name of my parametr" seems not to be the case; your typing skills as seen in this thread add to our suspicions that my diagnosis will be close.
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.