multiple recs through looping

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

Locked
sai123
Participant
Posts: 6
Joined: Wed Nov 17, 2010 4:22 am
Location: uk

multiple recs through looping

Post by sai123 »

Hi All,
Can you please let me know how to generate multiple recs from a single rec
ex:
i/p:
id,effdate
1,05/01/2011
2,11/01/2011

o/p:
id,effdate
1,05/01/2011
1,06/01/2011
1,07/01/2011
1,08/01/2011
1,09/01/2011
1,10/01/2011
1,11/01/2011
1,12/01/2011
1,13/01/2011
2,11/01/2011
2,12/01/2011
2,13/01/2011

ie I should get recs till currentdate()
thanks sai123
Thanks & Regards,
Sai
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How many times are you going to post this question ?!!!!!
:x
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sai123
Participant
Posts: 6
Joined: Wed Nov 17, 2010 4:22 am
Location: uk

Post by sai123 »

Hahah,this is very very imp req for me,I am struck on this,looking anyone has done in the past the same logic :roll:
Thanks & Regards,
Sai
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Please don't post a question multiple times or in multiple forums. If anyone wants to continue to help with this, here is the original thread:

viewtopic.php?p=387009

This one is done.
-craig

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