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
HASH FILE error
Moderators: chulett, rschirm, roy
DataStage is trying to open the file "/hILkp_CUSTOMERFORM". Does it exist right at the root level?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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?
<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