DSXchange

On the mainframe, is 0 9 one column or two?

Is either a packed column (e.g. COMP-3)?

Do you have a file on your DataStage server of the mainframe data with no conversion applied?

If so, try my tool, Create a hex/ascii dump of an ebcdic cobol file. This will give you a hex view of what is in the file.

You will find this tool on the DataStage Tools page of www.anotheritco.com.

Its a one column. All the values of the column are fine expect this value. Some of the example values that were convereted right are The file was on mainframe and we use FTP stage to read it. The data format in EBCDIC is Pic(x), its char in the sequential file and SQL.