Creating flat file with packeddecimal columns

Mohammad_Danish · Post by **Mohammad_Danish** » Thu Sep 22, 2011 7:23 am

I am trying to convert columns with double as datatype into Packed Decimal. Please provide me any pointers on how to accomplish this task using a parallel job and what datatype to use for these type of columns so that it can be directly picked up be an FTP program and send to mainframe GDG file?

jwiles · Post by **jwiles** » Thu Sep 22, 2011 1:26 pm

Packed Decimal is a decimal, so you should convert it to a decimal type before you send it to an output file. Have you looked at the options available for a decimal field in the metadata of a sequential file stage?

A simple search for "packed decimal" in the <a href="http://publib.boulder.ibm.com/infocente ... nformation Server 8.5 Information Center</a> pointed to <a href="http://publib.boulder.ibm.com/infocente ... html">this documentation</a>.

Also, consider using the Complex Flat File stage to create your output file. By default, it will create an EBCDIC/Mainframe compatible layout from your metadata.

Regards,