DSXchange

Hi,
We are reading in data from a Mainframe DB2 table defined as Decimal(3,0) and we are just passing this field through a transformer with the same metadata from the DB2 connector. The sequential file for this field ends up with a trailing decimal, is that expected?
ex: 123.

I know we can manipulate teh output if we declare it as a Varchar and do some basic string manipulation but wanted to check if this is the expected outcome for this scenario.

Thanks - - John

Yes it is expected. When converting decimal to string DataStage adds a decimal placeholder and sufficient leading and trailing nonsignificant zeroes to make it clear what the precision and scale settings are.

Hi Ray,
In our situation we are not converting to a string and the target column on teh sequential file is defined as Decimal(3). Is this behavior still expected in this scenario?
Thanks - - John

You ARE converting to a string, because a text file does not have data types - it only has text (string).

Actually, it's the export operator that is performing the conversion.

Thank You!!