Page 1 of 1
Update existin rows only option's warnings
Posted: Mon Oct 03, 2005 5:44 pm
by snassimr
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 ?
Posted: Mon Oct 03, 2005 6:45 pm
by chulett
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.
Posted: Mon Oct 03, 2005 8:44 pm
by ray.wurlod
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.
Posted: Tue Oct 04, 2005 7:25 am
by Bala R
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?.
Posted: Tue Oct 04, 2005 8:13 am
by chulett
As long as the performance is acceptable to you - no.