Assigning column headings for the SQL query result table
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://www.ibm.com/support/knowledgecenter/SSEPH2/welcome.
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:
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.SITE/LOCSITE SQLCol=Labels - Issue the following command if you want either a label or a name
to appear at the top of each column:
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.SITE/LOCSITE SQLCol=Any