Controls the display or suppression of headings in LIST command output.
SET HEADINGS ON|OFF
The HEADINGS option is set ON by default.
When you set HEADINGS OFF, output from the LIST and SELECT commands omits field headings from the columns displaying each field’s contents.
The HEADINGS setting affects the width of the columns output by LIST and SELECT. When headings are ON, the longer of the field’s width or its heading is used as the character width of the column in which the field’s content appears. When headings are OFF, the field’s width is always used to set the character width of the column.
set output ExportDoc
set headings off
list all Employees
set output terminal
The SET HEADINGS command is used to suppress headings when the output of a LIST command is being sent to a file.