Table load aborted, next run how to load remaining row

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
ksudhir466
Participant
Posts: 11
Joined: Fri Sep 05, 2008 4:20 am
Location: chennai

Table load aborted, next run how to load remaining row

Post by ksudhir466 »

Have ds px job loading to Table, it gets aborted after loading some records. In next run how to make sure that only remaining rows get loaded without altering previous loaded records
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

need more information .
what is the load method? Append or upsert or ...............??
what is your source? file or table?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Still, the short answer is keep track of where you last comitted and skip records the next run until you get past that point. This assumes you are loading from a static source.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply