Data can be extracted remotely from DB2 and easily loaded into spreadsheets or other applications.
2)
Note that some FTP clients do not support the site command, but may allow the command to be executed by preceding it with quote.
quote site ...
If the system that the data is to be downloaded to has an FTP server running, the data can be sent from an FTP client running on the host system. This allows the data to be sent automatically by scheduling the transfer as a batch job. In this case, the locsite command is used to set parameters on the local system where the FTP client is running.
locsite filetype=sqllocsite db2=db2xlocsite spreadput myquery.sql myquery.dat