data conversion

chucksmith · Post by **chucksmith** » Wed Dec 22, 2004 2:56 pm

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

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

chucksmith · Post by **chucksmith** » Wed Dec 22, 2004 3:01 pm

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.

dsrules · Post by **dsrules** » Wed Dec 22, 2004 3:06 pm

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

Code: Select all

0BVG40
0BVF43.

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.