HASH FILE error

arnie_nits · Post by **arnie_nits** » Thu Jul 09, 2009 1:42 am

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

ArndW · Post by **ArndW** » Thu Jul 09, 2009 1:49 am

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

arnie_nits · Post by **arnie_nits** » Thu Jul 09, 2009 1:59 am

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.

ArndW · Post by **ArndW** » Thu Jul 09, 2009 2:03 am

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.

ArndW · Post by **ArndW** » Thu Jul 09, 2009 2:04 am

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?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 09, 2009 7:29 am

Or the hash directory parameter not passed any value.