Can not delete a hashfile

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
branimir.kostic
Participant
Posts: 13
Joined: Thu Nov 04, 2004 4:30 am

Can not delete a hashfile

Post by branimir.kostic »

Hello everybody,

i created a job which writes to a hashfile specified to a directory. After the job-run (hashfile was created) I tried to set a pointer to this hashfile like this:

SET.FILE D:\HASHFILES\hash_RIS_to_vertrZURIS hash_RIS_to_vertrZURIS OVERWRITING

Now I want to delete the hashfile with its VOC-pointer. But I always get an error:

Cannot DELETE a remote File.
DELETEd file definition record "hash_RIS_to_vertrZURIS" in the VOC file.

I found in a UniVerse Userreference following description for this error:

the file definition (F-type) for SALES.EAST defines a file in
another account. DELETE.FILE does not delete the data file or the file dictionary,but it does delete the VOC entry that points to the remote files.

How can I delete the file? What does it mean the file is defined in another account?

Thanks for your reply
chucksmith
Premium Member
Premium Member
Posts: 385
Joined: Wed Jun 16, 2004 12:43 pm
Location: Virginia, USA
Contact:

Post by chucksmith »

I think SET.FILE is creating what is known to Universe as a Q pointer. My CreateVocPtr routine will create an F pointer. Try it, then use the Universe DELETE.FILE command to delete your hash file.

You can find the CreateVocPtr Before/After routine on the DataStage Tools page of www.anotheritco.com.
Post Reply