Creating the input data set

Before performing a DB2® SQL query using FTP, you must create an MVS™ data set that contains the SQL query you want to perform.

You can create queries on the client and use the FTP PUT command to send the queries to the MVS system to be processed. Or, you can prepare a group of SQL queries on the MVS system and perform them regularly.

Note: FTP can process only one SQL query per file.

For example, a data set on an MVS system named userid.SQL.IN contains the following SQL query:

SELECT LASTNAME, EMPID, YEARS_EMPLOYED FROM EMPLOYEE_TABLE
WHERE YEARS_EMPLOYED > 25

You either created that data set on the MVS system with TSO, or you used the FTP PUT command to put the data set on the MVS system.