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

["Peter Dow (ML)" <maillist@xxxxxxxxxxxxxxx>]

Hi Dave,

You might want to look into SQL2JXL from Giuseppe Costagliola's at 
McPressOnLine:

http://www.mcpressonline.com/tips-techniques/microsoft/techtip-excel-flies-higher-with-jexcelapi.html

Just supply it with an SQL statement and it will produce an Excel 
spreadsheet.  Then all you have to do is FTP it to the remote system.

*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

Dave Odom wrote:
> 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
>