Output format

FTP allows you to specify the format for the output of the SQL query, and choose column header.

The default report format puts one or more blank spaces between the columns, and it lists the SQL query, the column headings, and the resulting columns. You may also select the spreadsheet format option. The spreadsheet option puts a TAB character before the first character of each column entry, except the first column. The spread format enabled the SQL output data to be easily imported into a spreadsheet program. See your spreadsheet program documentation for instructions about how to import the output of the SQL query.

FTP also allows you specify if the column headers are determined from the column's name or label in the DB2 database.

To use the spreadsheet output format check the box labeled "Use spreadsheet format for query output (SPREAD)".

To use the DB2 database's column name, select the radio button labeled "Names of database columns". To use the DB2 database's column label, select the radio button labeled "Labels of database columns".

Since the column label is optional in DB2, if you chose to use column labels for the output header you also need to specify whether the column name or column number should be used if no column label is found.