Re: SQL select to DB2 through FTP

[Rob Berendt <rob@xxxxxxxxx>]

Probably.

If you'll settle for the data in a file and not the data as if you are running 
the SQL interactively you might want to try:

ftp somewhere
quote rcmd  call program to generate data
quit
some delay loop
ftp somewhere
get mylib/myfile
quit






sbireley@renex.com on 12/07/99 12:29:21 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        SQL select to DB2 through FTP

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
+---


+---
| 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
+---