DSXchange

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

Hi,
You can do it this way.

Mention the filename in the hash file stage as:

File#job_parameter_name#

For ex: File#1#

and also don't forget to add this parameter in the job properties dialog box. Once you do this, you should be able to use the defined job parameter.

Naveen.

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.

It doesnt work I get error :

DSD.UVOpen Unable to open file Hash#NUMBER#.

Is "NUMBER" your parameter - remember that parameters are case sensitive.

Yes . Its the exactly name of my parametr

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?

You have not defined that parameter in your job.

Sainath.Srinivasan wrote:You have not defined that parameter in your job.

one possbile reason is that you look up hash file before the file is crreated.

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.