Handling Packed PIC S9(7) COMP-3 field in CFF stage

poorna_76 · Post by **poorna_76** » Fri Aug 10, 2007 8:42 am

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?

ds_developer · Post by **ds_developer** » Mon Aug 13, 2007 9:40 am

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

ArndW · Post by **ArndW** » Mon Aug 13, 2007 3:38 pm

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.

ds_developer · Post by **ds_developer** » Mon Aug 13, 2007 3:50 pm

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

poorna_76 · Post by **poorna_76** » Tue Aug 14, 2007 9:22 am

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

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