FTP-supplied column headings

The FTP client and server provide column headings in the result table when DB2® does not. This occurs when a result table contains expression columns or when labels are requested and a database column that appears in the result table does not have a label defined.

FTP builds a column heading for expression columns. For example,

Select employee, salary/52 from ABC.Staff

results in two columns. The first column gets its name from DB2, while the second column is built by the server. The server uses the heading COL002 for the second column because it supports the SQL limit of 750 columns.