Hi,
I am using CFF stage to view data downloaded from mainframe. Everything looks right except the decimal columns have .. rather than a single . separating the scale and number.
Any help is appreciated.
Thanks
dsrules
CFF conversion issue
Moderators: chulett, rschirm, roy
CFF conversion issue
______________________________________
"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
dsrules - what is the Cobol PICture for the column?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
ArndW,
I fixed it :D . The error was the Meta data was s9(10)v99 but in the mainframe they were explicitly signed. I got them onto DataStage using pic x(12) then loaded them into sequential file as decimal. This works fine. Please let me know if I am doing a right thing.
Thanks
dsrules
I fixed it :D . The error was the Meta data was s9(10)v99 but in the mainframe they were explicitly signed. I got them onto DataStage using pic x(12) then loaded them into sequential file as decimal. This works fine. Please let me know if I am doing a right thing.
Thanks
dsrules
______________________________________
"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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Murphy's fourth postulate:
If it's stupid but it works, it's not stupid.
Your technique is entirely valid in server jobs, because the Engine does not use data types - everything is a string with implicit conversion governed by context (for example arithmetic). This helps DataStage to be tolerant of data type mismatches.
If it's stupid but it works, it's not stupid.
Your technique is entirely valid in server jobs, because the Engine does not use data types - everything is a string with implicit conversion governed by context (for example arithmetic). This helps DataStage to be tolerant of data type mismatches.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.