Consecutive Generic stages problem...

legendkiller · Post by **legendkiller** » Mon Oct 16, 2006 6:18 pm

Hi All,

I have job which has a sequential stage followed by two generic staage and a final sequential file stage.

In first generic stage I am copying input to output...say...
out.inputcolumn=in.inputcolumn

and in second generic stage i am doing
in.inputcolumn=substring(in.inputcolumn, 0,1)

my problem is datastage not executing lodic part in second generic stage and directly writing complete input value( as output of generic stage 1) in output rather that substring string( as output of second generic stage)...

Interestingly if i only keep second generic stage then that logic is working fine...

I have tried diff things like defining different columns...difining input and output schema on generic stages but...problem was not resolved...
Any Pointers to above probblem???

ray.wurlod · Post by **ray.wurlod** » Mon Oct 16, 2006 9:21 pm

Consecutive stages of the same type are not supported for some stage types, such as Modify stage. Put a Copy stage between them.

chulett · Post by **chulett** » Mon Oct 16, 2006 10:00 pm

And by 'generic' stage, I assume they mean... transformer?

ray.wurlod · Post by **ray.wurlod** » Tue Oct 17, 2006 8:37 am

No. There is a stage type called Generic. RTFM?

legendkiller · Post by **legendkiller** » Tue Oct 17, 2006 9:29 am

ray.wurlod wrote:No. There is a stage type called Generic. RTFM? ...

ya but i am calling transform operator...from generic stage.....

in a job if i put only one generic stage then it;s works fine.....problem is with secong genric stage.....it seems that job is just ignoring second generic stage....even preint_message statement are not displyaing anything for second generic stage

chulett · Post by **chulett** » Tue Oct 17, 2006 4:08 pm

ray.wurlod wrote:No. There is a stage type called Generic. RTFM?

Wondered about that right after I posted, but didn't feel like R'ing the FM so decided to expose my ignorance for all to see.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 17, 2006 7:36 pm

Put a Copy stage between them, as advised earlier in this thread.