Error when checking composite operator

irajasekharhexa · Post by **irajasekharhexa** » Fri Jul 06, 2007 4:43 am

Hi I have a field which is the type decimal type having length 15 and scale 2 having data ex 0000000000000.11 it has been defined same in all the stages.

But when I am trying to compare it is throwing error as

##W TFCP 000000 11:35:55(001) <transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
##E TFCP 000011 11:35:55(002) <transform> Error when checking composite operator: Parsing parameters "2,15" for schema type "decimal": Scale (15) is not <= precision (2)

Can pls anybody provide inputs why i am getting this error?.

Regds

ray.wurlod · Post by **ray.wurlod** » Fri Jul 06, 2007 9:48 am

Are you 100% certain that you have precision (length) and scale in the correct columns? Can you post the record schema that you are using? DataStage seems to believe you are using precision 2, scale 15.

irajasekharhexa · Post by **irajasekharhexa** » Fri Jul 06, 2007 9:58 am

ray.wurlod wrote:Are you 100% certain that you have precision (length) and scale in the correct columns? Can you post the record schema that you are using? DataStage seems to believe you are using precision 2, scale ...

Hi Ray,

I was used reversily in StageVariables.That's why it was throwing Error. I was used earlier Precission as 2 and scale as 15. Now inter changed these values. It's working fine.

Thanks Ray

Regds