When you create a DB2® table, you can assign descriptive labels to the table columns. For example, a column name could be XCM554, but the label could be WEEKLY PAY. For information about assigning names and labels, see http://publib.boulder.ibm.com/infocenter/imzic.

The SQLCol parameter of the SITE command enables you to specify whether you want names or labels to appear at the top of the columns in your output file. The default value is Names.

• Issue the following command if you want a database column name to appear at the top of each column in your output file:

  SITE/LOCSITE SQLCol=Names

• Issue the following command if you want a label to appear at the top of each column:

  SITE/LOCSITE SQLCol=Labels

  If you specify the Labels parameter, and a column in your query does not have a label defined in the database, the FTP server supplies a column heading. For more information about column headings, see FTP-supplied column headings.
• Issue the following command if you want either a label or a name to appear at the top of each column:

  SITE/LOCSITE SQLCol=Any

  If you specify the Any parameter, the label appears as the column heading. However, if the column does not have a label, the name appears at the top of the column.