Page 2 of 2

Posted: Wed May 21, 2003 11:18 am
by tonystark622
Thanks for enlightening me, Craig. I have never seen this explained this way in the documentation. I appreciate your help.

Tony

Posted: Wed May 21, 2003 6:48 pm
by ray.wurlod
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

Posted: Thu May 22, 2003 6:55 am
by tonystark622
Thanks, Ray!

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

Thanks again,
Tony