A couple things - if you make the outfile have only character and zoned fields, you can FTP it directly to wherever as a fixed-length file - not a delimited one - well, you can also make it have the delimiters yourself, if you want to concatenate them all in.

There is no magic to using FTP to a Windows box - except there has to be an FTP server running on the Windows box. What trouble are you having - it was not clear from your post!

But I suggest using NFS - you can put it on the blade server - free from Microsoft - then mount the NFS share on the IFS and it is a simple CPY to it. You can see more on our wiki at http://wiki.rjssoftware.com/wiki and search for NFS


At 06:50 PM 3/20/2008, you wrote:

I do regular FTPing all the time between the native i5 file structure (libname/filename.membername) and other systems like Windows but can't seem to figure out how to do this.

What I'm doing is:

Running a DB2 Query Manager query with the output to an outfile.
Running the CPYTOIMPF to move/convert the outfile to a CSV file in the IFS, i.e., /home/dodom1/filename.csv
Here I want to FTP the file from the IFS to a Windows subdirectory on one of our blade servers.

Thanks in advance,

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].