DSXchange

Hi,

I have a requirement to create a fixed width file with COBOL datatypes
(PIC X(2), PIC S9(7)v99, PIC S9(05) COMP-3, PIC 9(10) COMP-3)
whereas my source is oracle.

I understand we could use a sequential file if all the decimal fields are one of these (packed or zoned or overpunch)

But here in my target file there are packed, zoned and overpunch values.
Can CFF stage be used here?

This has to be done in Parallel jobs.

Your suggestions on this please

Thanks,
Bala

I'm not at a DS pc right now, but seem to recall that the CFF stage in Server is only for reading, but on PX it can be used for both reading and writing. Have you tried to write to the stage?

Pic X(2) and Pic S9(7)v99 must be straight-forward.

For Comp-3, ArndW provided a routine.

In PX, you can use CFF as output.

I tried writing to the CFF stage and it works. I have created the file after all trial and errors, learning the relation between oracle datatype and cobol datatype . But i am not sure whether the compressed variables would be read with the same values in MF. I will post again when the file is tested in MF for the data.

Thanks for your posts...