Can existing dataset be insert/update.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
tkbharani
Premium Member
Premium Member
Posts: 71
Joined: Wed Dec 27, 2006 8:12 am
Location: Sydney

Can existing dataset be insert/update.

Post by tkbharani »

Dear All
After searching , I am posting this question.

In server jobs we have Hash file,which is Insert/Update using a particular unique key. In the same way I tried using DataSet stage in parallel,but this does not work as insert/update using key. Is there any way to use Dataset as Update/insert , or Datasets doesn't server this purpose.
As migration is going on from server jobs to parallel jobs ..what is the best way to use server hash stage in parallel jobs.
Thanks, BK
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

DataSets cannot be updated as can database tables. You can append to a DataSet but you cannot update records.
It does not make sense to use hashed files in parallel jobs; much better to redesign jobs so that you have no need for hashed file type constructs.
Post Reply