Page 1 of 1

Can existing dataset be insert/update.

Posted: Fri Feb 29, 2008 12:58 am
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.

Posted: Fri Feb 29, 2008 3:42 am
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.