Hi,
I have a simple server job which loads data from file to database.The file is ftped from mainframe to windows server.The problem is the values for input double columns is coming as
0000000{0000000{0000000{0001000.
The length of each field is 8.The job is getting failed because of } in the data.
Please advice!
Problem with double
Moderators: chulett, rschirm, roy
It looks like these might be COMP-3 or binary values; or your column length is really only 7 and you have a { as the separator.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Yes. You could re-convert them to binary after transfer using EBCDIC(In.ColumnName) and then apply one of the SDK routines to convert the binary to a text number representation. Or transfer in binary mode and use the CFF stage.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Great, I'm glad you got that sorted out. If you could mark this thread as resolved other future searchers will get a quicker and better answer as well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>