Deleting hash files

gpbarsky · Post by **gpbarsky** » Tue Sep 16, 2003 9:40 am

Hi.

I need to know how can I delete a hash file, which is stored in the directory of the project.

As far as I understand, a hash file has a file and a directory with a name like its name.

Is there a way to delete a hash file ?

Thanks in advance.

Guillermo P. Barsky
Buenos Aires - Argentina

roy · Post by **roy** » Tue Sep 16, 2003 9:51 am

Hi,
You can issue a TCL DELETE.FILE command,
or you can use the CLEAR.FILE if it is enough for what you need.
this should be easy since you said this is an "acount" (in the project directory) hash file.

in case it resides in another location it needs several commands prior to using the above commands.

you can find previous topics here just use the search here.
also you can use the manuals.

IHTH (I Hope This Helps),

Roy R.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 16, 2003 4:37 pm

The command for deleting a hashed file depends on how it was created and whether it's static or dynamic. And, possibly, the operating system (UNIX or Windows).
If it was created with CREATE.FILE, it is deleted with DELETE.FILE.
If it was created with CREATE TABLE, it is deleted with DROP TABLE.
If it was created with mkdbfile, it is deleted with rm (UNIX) or del (Windows), which must be recursive if the hashed file is dynamic.
The command that created the hashed file was logged when it was created, if that was performed by DataStage.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518