how to empty a HASH file?
Moderators: chulett, rschirm, roy
how to empty a HASH file?
hi
can anybody tell me how to empty a hash file?
can anybody tell me how to empty a hash file?
Re: how to empty a HASH file?
You can delete the file. It's better for us to explain if you post exactly wat you need.qutesanju wrote:hi
can anybody tell me how to empty a hash file?
Thanks,
Veera
Thanks in advance...
veera...
veera...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Create a job that sends 0 rows, but has "clear before write" set. Or has "delete before create" set. If there is a VOC entry for the hashed file you can also use the CLEAR.FILE command (which the first of the above choices does under the covers).
Last edited by ray.wurlod on Wed Dec 24, 2008 2:41 pm, edited 1 time in total.
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.
-
- Premium Member
- Posts: 41
- Joined: Tue Jul 08, 2008 5:45 am
- Location: Columbus
Re: how to empty a HASH file?
Simply you can add a transformer before hashed file and you can pass null values to the columns and as Ray mentioned you have check the option ''Delete file before create".
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: how to empty a HASH file?
That is wrong. What you do is set up a constraint expression (such as @FALSE) that allows no rows at all to pass. If you send NULL to a key column you end up with a warning in the job log. You ought never to generate warnings from server jobs.Sathishkumarins wrote:Simply you can add a transformer before hashed file and you can pass null values to the columns ...
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.
Re: how to empty a HASH file?
And, for the trifecta, you also need to add a stage variable to the transformer so the job will compile. And while you cannot 'pass null values' you can set their derivation to @NULL with the @FALSE constraint that Ray mentioned.ray.wurlod wrote:That is wrong. What you do is set up a constraint expression (such as @FALSE) that allows no rows at all to pass. If you send NULL to a key column you end up with a warning in the job log. You ought never to generate warnings from server jobs.Sathishkumarins wrote:Simply you can add a transformer before hashed file and you can pass null values to the columns ...
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Correct terminology is HASHED file, not "hash" file.
To empty a hash file I imagine you would use a wire brush of some kind.
A hash file is a tool for shaping a block of hash.
To empty a hash file I imagine you would use a wire brush of some kind.
A hash file is a tool for shaping a block of hash.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3
- Joined: Sat Oct 20, 2007 12:51 pm
- Location: Chennai
-
- Premium Member
- Posts: 20
- Joined: Tue Dec 16, 2008 10:09 am
- Location: Lisboa