DSXchange

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

qutesanju wrote: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

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

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

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

Sathishkumarins wrote: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.

ray.wurlod wrote:

Sathishkumarins wrote: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.

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.

hash can also be smoked ..lol..

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

Hi,

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

clear.file hash_file_name

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.

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.