Re: SQL select to DB2 through FTP

[Patrick Townsend <townsend@xxxxxxxxxxxxxx>]

Steve,

I don't think the FTP server supports an SQL file type, but you could
use the remote command support to pass a program a SQL string to
execute, put output in a file, then pull it back with FTP.

Patrick

Steve Bireley wrote:
> 
> Is it possible to send a SQL select to DB2 through FTP and have the result
> sent back to the FTP client?  On MVS OE you can use "locsite file=sql" to
> execute a SQL select and get the results
> 
> TIA
> 
> Steve Bireley
> Renex Corp
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

-- 
IBM AS/400 communications, FTP automation, and network security
software and consulting services.

http://www.patownsend.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---