Insert and update a table

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
Archana
Participant
Posts: 15
Joined: Thu Mar 23, 2006 3:55 am
Location: Hyderabad
Contact:
Contact Archana

Insert and update a table

Post by Archana »

If you have single input sequential file as an input in one of the server jobs and you have got to insert and update a table .

I want to insert the keys if the keys are not present in the table and also update other columns(other than keys) from the input file fo the inserted keys. Can I do it ?
Archana
Top
Sunshine2323
Charter Member
Charter Member
Posts: 130
Joined: Mon Sep 06, 2004 3:05 am
Location: Dubai,UAE

Post by Sunshine2323 »

Hi Archana,

Check This Post

Also what is your target?
Warm Regards,
Amruta Bandekar

<b>If A equals success, then the formula is: A = X + Y + Z, X is work. Y is play. Z is keep your mouth shut. </b>
--Albert Einstein
Top
Post Reply

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