Controls the display or suppression of headings in LIST command output.

Syntax

SET HEADINGS ON|OFF

Comments

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.

Example

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.

See Also

LIST

SET PAGESIZE

SET PAUSE