how to empty a HASH file?

[qutesanju]

hi
can anybody tell me how to empty a hash file?

[veera24]

hi
can anybody tell me 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.

Thanks,
Veera

[ray.wurlod]

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).

[Sathishkumarins]

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".

[chulett]

Have to? No, you can simply 'Clear' the hashed file as well.

[ray.wurlod]

Simply you can add a transformer before hashed file and you can pass null values to the columns ...

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.

[chulett]

Simply you can add a transformer before hashed file and you can pass null values to the columns ...

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.

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]

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.

[rameshrr3]

hash can also be smoked ..lol..

[ray.wurlod]

I wonder how you know that? Ah yes, California...

[ragavendradinesh]

Hi,

You can clear a hashed file using the following command in the Execute option in Administrator.

clear.file hash_file_name

[SoaresRui12]

You can do the command uv, clear.<hashed file> in the "after job" option and clear the hashed file that have used in this job.
If it's that you are ashed.

[chulett]

That's already been noted along with the fact that that requires a VOC entry, i.e. an account-based hashed file or a pathed hashed file with a manually created VOC record.