Query Output Table Contains Bad Characters

 

Problem Statement:

Using Query to generate an output table on the iSeries. The resulting decimal field contains strange characters that appear as green squares and unwanted strings of 404040.

Solution:

Decimal field data in a data file on the iSeries cannot be displayed correctly by displaying the physical file member due to the mechanism used by DB2/400 to store the data. Using the CAST function on the fields to convert from DECIMAL to CHARACTER using SQL to get all data in character format for .CSV files. The TRIM functions may be used to remove extra spaces.

Ref#: 1476277