SQLCOL (FTP client and server) statement

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

Read syntax diagramSkip visual syntax diagram
   .-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

Related topics