warning while creating a hash file

sujaoschin · Post by **sujaoschin** » Tue Sep 02, 2008 6:59 pm

I am creating a hash file from db2 table for the purpose of lookup. In db2 the column 'biseps_modelnum' has both null values and values. This biseps_model num is the key for the lookup. When I am running the job, I am getting this below warning as null records are there. How to avoid this warning?

SCTA_T_ITEMS_HASH_forAltItem..oh_HASH_AltItem.Hash_Data: ds_uvput() - Write failed for record id '<Missing or NULL>'

ray.wurlod · Post by **ray.wurlod** » Tue Sep 02, 2008 9:04 pm

Stick in a Transformer stage with a constraint that does not pass NULL keys to the hashed file.

And it's "hashed" file, by the way, not "hash" file.

sujaoschin · Post by **sujaoschin** » Wed Sep 03, 2008 5:22 pm

Thanks, Ray. This problem is resolved and I used the below in transformer stage to avoid the warnings and filter out null records.

Not(IsNull(lookup_BISEPS_MODELNUM.BISEPS_MODELNUM))