Page 1 of 1

Need to ignore data elements in ODBC update

Posted: Tue Dec 28, 2004 10:04 am
by rdy
In a server job, I have a sequential file that feeds an ODBC stage. The ODBC stage uses the update action "Update existing rows only".

Since I am re-using this sequential file in a later process, I would like to have more input columns than are used in the update. (i.e. 5 columns in sequential file, only 4 get updated in ODBC stage.)

Is this possible? How do I set it up?

Re: Need to ignore data elements in ODBC update

Posted: Tue Dec 28, 2004 10:07 am
by ogmios
Read the extra column in the sequential stage but don't connect it to anything in the transformer.

Ogmios