I am using Syncsort to select records from Db2. For the columns that are either decimal(9,8) or smallint the output looks weird with junk characters in it. If I cast the column to CHAR type in the select statement the output is proper. I do not want to cast the column type to char in the SQL statement rather I want a solution in syncsort if this is possible.
For example: the decimal column has a value 2.98965467 which is displayed in a non-readable format by Syncsort if I don't use casting in the SQL statement. Kindly help