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.
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.
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.