Update existin rows only option's warnings

snassimr · Post by **snassimr** » Mon Oct 03, 2005 5:44 pm

Hi !

I need DS dont issue warning message if update sttaement dont find combination of keys for update statment. If it possible with ODBC stage ?

chulett · Post by **chulett** » Mon Oct 03, 2005 6:45 pm

Sure - stop sending update rows to it for keys that don't exist.

Seriously... hashed file lookup... existing keys... only issue an update when you get a hit on the hashed file.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 03, 2005 8:44 pm

DataStage faithfully logs every warning it receives.

That way you can't sue IBM for not letting you know.

As Craig says, you can't suppress this; you must implement a design that does not generate the warnings in the first place. Such a job design will give you the additional benefit of running more efficiently.

Bala R · Post by **Bala R** » Tue Oct 04, 2005 7:25 am

I have used the same tables as lookup using OCI stages, before I insert or update. Started the design with hashfile lookups and later changed to DB lookups. Have I gone down the wrong path?.

chulett · Post by **chulett** » Tue Oct 04, 2005 8:13 am

As long as the performance is acceptable to you - no.