Problem with double

sravanthi · Post by **sravanthi** » Mon Dec 17, 2007 11:57 am

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!

ArndW · Post by **ArndW** » Mon Dec 17, 2007 11:59 am

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.

sravanthi · Post by **sravanthi** » Mon Dec 17, 2007 12:26 pm

Thanks for your advice.

Is there any possible way of converting COMP fileds to decimal or interger values.

ArndW · Post by **ArndW** » Mon Dec 17, 2007 12:29 pm

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.

sravanthi · Post by **sravanthi** » Mon Dec 17, 2007 12:39 pm

Thankyou.

It is working now.I have used:

DataTypePicS9(Ebcdic(Lnk_Trns.DEDUCT_AMT))

sravanthi · Post by **sravanthi** » Mon Dec 17, 2007 12:40 pm

Thankyou.

It is working now.I have used:

DataTypePicS9(Ebcdic(Lnk_Trns.DEDUCT_AMT))

ArndW · Post by **ArndW** » Mon Dec 17, 2007 12:52 pm

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.