Previous record

datastagenewbie · Post by **datastagenewbie** » Tue Jul 14, 2009 1:12 pm

How do I get previous record and next record info in DataStage Parallel job ?

chulett · Post by **chulett** » Tue Jul 14, 2009 1:32 pm

You don't, really. Stage variables can store values from a 'previous' record, however. What are you trying to do?

datastagenewbie · Post by **datastagenewbie** » Tue Jul 14, 2009 1:37 pm

I need a column value of the previous record. If the value is the range then I will do additional processing(setting a flag) to the current record.

chulett · Post by **chulett** » Tue Jul 14, 2009 2:08 pm

OK, very common requirement. Stage variables in a Transformer will let you do that easily. Ever used them before?

datastagenewbie · Post by **datastagenewbie** » Tue Jul 14, 2009 2:14 pm

I've never used them. But I think I can find some help in the dox and use them.
Thank you very much.

chulett · Post by **chulett** » Tue Jul 14, 2009 2:21 pm

Keep in mind they are processed top to bottom, which is key here, so make sure the one you use to store the 'previous' value is last in the order listed.

datastagenewbie · Post by **datastagenewbie** » Tue Jul 14, 2009 3:18 pm

Thank you!