Using Zoned DataType Fields

imbos123 · Post by **imbos123** » Wed Mar 21, 2007 2:28 pm

Hi,

I get a file from mainframe. Its a fixed length file. There is a amount field which is of zoned data type.
My requirement is to aggregate this data and out put that in zoned data type format.

Which datatypes should I use in Datastage? I believe I cannot use decimal data type for adding zoned data type data. Please correct me if I am wrong.

DSguru2B · Post by **DSguru2B** » Wed Mar 21, 2007 4:37 pm

Look into sequential file stage. It has property of ebcidic to ascii in its properties, under format tab. See if that works.
Else use server job as it has a function that converts PicS9 to ascii. That will work for you as I looked at zoned sample data hereand its the same as as PicS9. I have done this in a server job.
Else if you have to have to, absolutely have to, stick to a px job then its not hard to write a C routine to do this for you. The rules are defined in the embeded link.

chulett · Post by **chulett** » Wed Mar 21, 2007 4:57 pm

Would not the CFF stage handle these?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 21, 2007 6:30 pm

A Complex Flat File stage has the inherent capacity to handle most mainframe data types, whether display or computational, including signed and unsigned, zoned, packed, etc.