On the mainframe, is 0 9 one column or two?
Is either a packed column (e.g. COMP-3)?
data conversion
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
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.
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.
Chuck Smith
www.anotheritco.com
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.
Code: Select all
0BVG40
0BVF43.
______________________________________
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane
"Everytime I close the door on reality, it comes in through the windows." - Jennifer Yane