RE: How do I FTP from the IFS to a Windows blade server?

Hi Dave

If you just shared the home directory using netserver the ftp would not be
necessary at all.

Regards
Evan harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: Saturday, 22 March 2008 12:02 p.m.
To: midrange-l@xxxxxxxxxxxx
Subject: Re: How do I FTP from the IFS to a Windows blade server?

Found the following is all that's necessary:

ftp '166.nn.nnn.nn'
userid
pw
na 1
put /home/dodom1/ivrobjs.csv ivrobjs.csv

So, the complete process is:

Run a DB2 Query Manager query with the output to an outfile.
Run CPYTOIMPF to move/convert the outfile to a CSV file in
the IFS, i.e., /home/dodom1/filename.csv
ftp '166.nn.nnn.nn'
userid
pw
na 1
put /home/dodom1/ivrobjs.csv ivrobjs.csv

Automate the above via REXX and i5 scheduler or invoke the REXX program
interactively from a screen.

This allows you to run a Query Manager query, convert its output to CSV and
move it to a server where those that "need" the i5 data in Excel or Access
can have it.

Thanks,

Dave