Decimal error while compiling

theone · Post by **theone** » Mon May 23, 2011 9:32 am

I receive error "Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255" while compiling the job

I have source field CODE_ID as decimal (8,0) in oracle and target as CODE_ID as decimal (8,0) in teradata with fastload utility as the table is new with no data.

Any inputs greatly appreciated,

Thank you.

ray.wurlod · Post by **ray.wurlod** » Mon May 23, 2011 2:35 pm

Check that you have a non-zero, non-blank value actually in the Precision part of the decimal declaration. DataStage is finding one of these.

theone · Post by **theone** » Wed May 25, 2011 8:08 am

Thanks Ray, as I mentioned it is Decimal (8,0).. is it okay if I have a non zero value in precision?

ray.wurlod · Post by **ray.wurlod** » Wed May 25, 2011 5:30 pm

It's not only OK, it's mandatory. But DataStage thinks there's a zero or empty precision in there somewhere. Enable the environment variable that dumps schemas (from memory it's something like OSH_PRINT_SCHEMAS) to get a more detailed diagnosis.

chandra.shekhar@tcs.com · Wed May 25, 2011 11:33 pm

Plz check if you are using any stage variables, if yes then change their datatype to varchar(255)

theone · Post by **theone** » Thu May 26, 2011 7:12 am

I did not use any stage variables.. I know how to handle it using MLOAD but as of now I am using fastload..