FTP.DATA updates for SQL query function

To obtain FTP.DATA updates for the SQL query function, follow these steps:

  1. Set the FTP.DATA DB2® statement to specify the name of the DB2 subsystem.
  2. Set DB2PLAN to specify the DB2 plan to be used by the FTP server.
  3. Set the SPREAD statement to specify whether SQL output is in spreadsheet format.
  4. Set SQLCOL to specify the column headings of the output data.