DSXchange

Hi,

I have got an error when I tried to use a hash file for look up. I am unable to get the solution.
Below is the error:
CUSTOMERFORM_Delta..hLkp_F_TCLIENT_CONTACT.IDENT1: |CUSTOMERFORM_Delta..hLkp_F_TCLIENT_CONTACT.ILkp_F_TCLIENT_CONTACT: DSD.UVOpen mkdbfile: invalid number of arguments
SH: line 2: /hILkp_CUSTOMERFORM: No such file or directory
.|


Please help.

Regards,
Arnie

DataStage is trying to open the file "/hILkp_CUSTOMERFORM". Does it exist right at the root level?

Well, actually I am new to server jobs and hash files.....what I am trying to do is a delta load....in the first run itself the job got aborted with that error.....
So my doubt is... should there be a hash file in the directory before the first run??
Please tell me how to do this....


Thanks and regards,
Arnie.

Normally a hashed file should not be in the root directory, and since you are using this file as a reference lookup it must exist at runtime.

I just saw the "SH" (for "SH"ell) in the error message. Could it be that your job has a before-job call which might create this file using the mkdbfile command?

Or the hash directory parameter not passed any value.