DSXchange

I am using DataStage Server Version 7.5.1. on Windows. One of the FTP'd file from mainframe has one field as Packed PIC 9(10) COMP-3. When I use this file in the CFF Stage, CFF stage is not converting it and shows some incorrect value. I am using this field as BINARY (6) in the CFF stage.

I tried right-click on the Source Column row for that particular field and selected 'Edit Row' option and in the COBOL definition in the bottom selectded COMP-3 usage option. Still it is not working.

Can someone please let me know how to handle packed fields in CFF stage?

It sounds like your datatype is wrong to me. A PIC 9 would be an integer, not binary. In the subject you say PIC S9(7) which is a signed integer seven long. In the body you say PIC 9(10) which is an integer 10 digits long. You need to decide which it is and change the CFF layout accordingly.

John

ds_developer - this a COMP-3 type, so it is binary and packed.

poorna_76 - did you specify a binary FTP? If not, if would corrupt packed field contents.

My bad . I was focusing on the field the data would go into, not what it was in the file. Sorry if I mislead anyone.

John

I did a BINARY FTP and chose EBCDIC dataformat and it worked.

ArndW and ds_developer - Thanks for the help. Appreciate it.