Clearing a hash file

tonystark622 · Post by **tonystark622** » Wed May 21, 2003 11:18 am

Thanks for enlightening me, Craig. I have never seen this explained this way in the documentation. I appreciate your help.

Tony

ray.wurlod · Post by **ray.wurlod** » Wed May 21, 2003 6:48 pm

There are two options.

You can create a VOC entry using SETFILE. Syntax for this command is:
SETFILE [pathname] [VOCname] [OVERWRITING]
For example:
SETFILE /usr2/data/hashedfiles/CustCodes CustCodes
Then you can use CLEAR.FILE successfully.

The other choice is to execute clear.file from the operating system shell. This command is located in DataStage Engine's bin directory; you can use its full pathname or have that bin directory in your PATH.
For example:
`cat /.dshome`/bin/clear.file /usr2/data/hashedfiles/CustCodes

tonystark622 · Post by **tonystark622** » Thu May 22, 2003 6:55 am

Thanks, Ray!

Now that DataStage is my main focus at work, these kinds of things are very handy to know.

Thanks again,
Tony