Need to ignore data elements in ODBC update

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
rdy
Participant
Posts: 38
Joined: Wed Nov 05, 2003 2:40 pm

Need to ignore data elements in ODBC update

Post 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?
Top
ogmios
Participant
Posts: 659
Joined: Tue Mar 11, 2003 3:40 pm

Re: Need to ignore data elements in ODBC update

Post by ogmios »

Read the extra column in the sequential stage but don't connect it to anything in the transformer.

Ogmios
In theory there's no difference between theory and practice. In practice there is.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”