Performing an SQL query from an FTP server

Procedure

To have the FTP server perform the query and have the results sent to the client, specify:
```
SITE FILEtype=SQL
```
Perform a GET command specifying the name of the file on the server that contains the SQL query.

Example

For example, if the server has a file named userid.SQL.IN that contains an SQL query, you can specify:

GET SQL.IN SQL.OUT

The FTP server then submits the query found in SQL.IN to the DB2® subsystem on the server and sends the resulting rows of output to the client to be put into SQL.OUT on the client.