Consecutive Generic stages problem...
Posted: 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???
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???