Thank you all - I'll pass this info along. Regards, Jasbir
-----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of John McKown Sent: Wednesday, February 04, 2009 9:53 AM To: IBM-MAIN@bama.ua.edu Subject: Re: convert DB2 data to a flat file <quote> You can go directly from I to Z via ftp. Beware of Date fields and packed fields. Depending on which language the Z is going to use, it may not be able to handle it. When I do this, I make sure all data is character or zoned. I have consistently moved data from the I to Z with this technique. The CPYTOIMPF you can "format" with the type of delimiter or fixed format you want. You can also define the end of record delimiter you want to use. I would go directly from I to Z rather than CPYTOIMPF. Sharon Wintermute </quote> ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html