convert DB2 data to a flat file

2009-02-04 Thread Chauhan, Jasbir
One of my clients is running a DB2 application on an iSeries system (not sure about the version). Their goal is to send us DB2 application data in the form of a flat file that can then be loaded to a non-DB2 application on our z/OS system (1.9). Is there a third party product or a utility they

Re: convert DB2 data to a flat file

2009-02-04 Thread Rich Smrcina
Chauhan, Jasbir wrote: One of my clients is running a DB2 application on an iSeries system (not sure about the version). Their goal is to send us DB2 application data in the form of a flat file that can then be loaded to a non-DB2 application on our z/OS system (1.9). Is there a third party

Re: convert DB2 data to a flat file

2009-02-04 Thread Gerry Anstey
cc Discussion List ibm-m...@bama.ua Subject .edu convert DB2 data to a flat file

Re: convert DB2 data to a flat file

2009-02-04 Thread John McKown
Oh, you might also want to look at the CPYTOIMPF command on the iSeries. It is built-in. But I don't really know what its output looks like. iSeries info center is at: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp -- John

Re: convert DB2 data to a flat file

2009-02-04 Thread Chauhan, Jasbir
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

Re: convert DB2 data to a flat file

2009-02-04 Thread John McKown
I asked this question on the midrange-l forum and got the following response from one person: 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

Re: convert DB2 data to a flat file

2009-02-04 Thread John McKown
On Wed, 4 Feb 2009 08:10:12 -0500, Chauhan, Jasbir jasbir.chau...@fiserv.com wrote: One of my clients is running a DB2 application on an iSeries system (not sure about the version). Their goal is to send us DB2 application data in the form of a flat file that can then be loaded to a non-DB2