Performing an SQL query from an FTP client

Procedure

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

Example

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

PUT SQL.IN SQL.OUT

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

To return to normal FTP processing, specify:

LOCSITE FILEtype=SEQ