Use the SQLCOL statement to specify the column headings of the output file when FILETYPE is SQL.
- Server
- This setting applies when format is output from the server.
- Client
- This setting applies when format is output from the client.
Syntax
.-SQLCOL NAMES-------. >>-+--------------------+-------------------------------------->< '-SQLCOL--+-ANY----+-' +-LABELS-+ '-NAMES--'
Parameters
- ANY
- Use the label, but if there is no label, the name becomes the column heading.
- LABELS
- Use the label of the column headings. If any of the columns do not have labels, the server uses COLnumber, where number is the column number reading left to right.
- NAMES
- Use the name of the column headings and ignore the labels. This is the default.
Examples
Use the label of the column headings:
SQLCOL LABELS