split by month

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
consulting
Participant
Posts: 50
Joined: Fri Dec 21, 2007 3:24 am

split by month

Post by consulting »

My reqriment is to split the records by month in to 12 sequentil file.
I am trying to split it in tansformer stage by giving the constarint linkname=01(month)
...up to linkname 10 it is working if i give linkname=11 during compilation it gives error.


thanks
Balaji G
balaji
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Could you be kind enough to tell us what the error is?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Indeed please explain your job design in detail as well.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
consulting
Participant
Posts: 50
Joined: Fri Dec 21, 2007 3:24 am

Post by consulting »

1)i have a sequntial file with date column
2) the next transformer stage i extract the month from date
3) i give it to copy stage
4)from copy stage i link to transformer stage in this stage i split it by month by giving constraints like dslinkname=01
dslinkname=02 dslinkname=03 dslinkname=04 dslinkname=05 dslinkname=06 dslinkname=07 dslinkname=08 dslinkname=09 dslinkname=10 it works fine up to this it i give next constraint dslinkname=11 during compilation itself it fails
balaji
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

consulting wrote:...dslinkname=11 during compilation itself it fails...
With what error?
Post Reply