datastage concept

prasson_ibm · Post by **prasson_ibm** » Thu Sep 04, 2008 1:14 pm

Hi all,
I have one job and it has transferred 100 records after that it aborts. I have added one one more record that is 101.Now i want my job to start from 101...for this what i have to do.....?

thanks in advance

chulett · Post by **chulett** » Thu Sep 04, 2008 1:43 pm

Add a parameterized constraint to skip the first X records where this time X = 100. And please don't post in all bold, it makes the baby jesus cry.

vmcburney · Post by **vmcburney** » Thu Sep 04, 2008 7:45 pm

But fortune favours the bold.

chulett · Post by **chulett** » Thu Sep 04, 2008 8:14 pm

D'oh! :D

chpraveen.msc · Post by **chpraveen.msc** » Fri Sep 05, 2008 7:38 am

Gurus,
I Agree with your answer. But we need to configure it manually. Apart from capturing the record count and reloading the records from the point where it got aborted. Is there any way that Datastage will handle the situation on its own(with out keeping track of the records or by giving the Parameter contraint as said by chulett).

chpraveen.msc · Post by **chpraveen.msc** » Fri Sep 05, 2008 7:40 am

Gurus,
I Agree with your answer. But we need to configure it manually. Apart from capturing the record count and reloading the records from the point where it got aborted. Is there any way that Datastage will handle the situation on its own(with out keeping track of the records or by giving the Parameter contraint as said by chulett).

ray.wurlod · Post by **ray.wurlod** » Fri Sep 05, 2008 5:51 pm

No. Somewhere it must keep track. Otherwise there's no way to establish the restart point.

prasson_ibm · Post by **prasson_ibm** » Sat Sep 06, 2008 5:05 am

Hi all
thanks a lot for ur replies.....