HashFile
Moderators: chulett, rschirm, roy
-
rajsimha123
- Participant
- Posts: 3
- Joined: Thu May 20, 2004 1:10 am
HashFile
How to delete or clear the hashfile from the command line?
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You should be able to find the answers by searching the Forum. The command used to delete a hashed file depends on the command that was used to create the hashed file, and whether a SETFILE command has been issued since.
The command to clear the contents of a hashed file is CLEAR.FILE if issued from within the DataStage environment, or clearfile from the operating system. You can also use SQL within the DataStage environment (DELETE FROM hashedfile;) or the TCL command DELETE with an active Select List.
The command to clear the contents of a hashed file is CLEAR.FILE if issued from within the DataStage environment, or clearfile from the operating system. You can also use SQL within the DataStage environment (DELETE FROM hashedfile;) or the TCL command DELETE with an active Select List.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.