Page 1 of 1

Consecutive Generic stages problem...

Posted: Mon Oct 16, 2006 6:18 pm
by legendkiller
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???

Posted: Mon Oct 16, 2006 9:21 pm
by ray.wurlod
Consecutive stages of the same type are not supported for some stage types, such as Modify stage. Put a Copy stage between them.

Posted: Mon Oct 16, 2006 10:00 pm
by chulett
And by 'generic' stage, I assume they mean... transformer? :?

Posted: Tue Oct 17, 2006 8:37 am
by ray.wurlod
No. There is a stage type called Generic. RTFM?

Posted: Tue Oct 17, 2006 9:29 am
by legendkiller
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

Posted: Tue Oct 17, 2006 4:08 pm
by chulett
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.

Posted: Tue Oct 17, 2006 7:36 pm
by ray.wurlod
Put a Copy stage between them, as advised earlier in this thread.