The format in which the result of a SELECT statement is displayed depends on the formatting mode that is in effect when the result is returned. ITEQ formatting modes are Format or Unformat.
You use Format mode to tailor a result into a report (Chapter 6), which may be viewed or printed for later reference. When a result is displayed in Format mode, the processing message that contains the statistics for the result is displayed by itself as the first result “page.” Selected data is formatted into consecutive pages, each containing date, page number, report title, and column headings.
You use Unformat mode for viewing data on the terminal screen (although an unformatted result may also be filed or printed). When a result is displayed in Unformat mode, the processing message, along with selected data and column headings, are displayed as a single entity. If the result exceeds the size of the display area, you may view the result as consecutive screen pages without column headings or other embellishment.
Unformat mode is used here to show you how to use display control commands. Nevertheless, display control commands are likewise used to display a formatted result. When you log onto ITEQ and begin a session, Unformat mode is automatically set and remains in effect until changed. To change to Format mode, execute the command:
SET FORMAT; (or SET FORMAT ON;)
Any subsequent SELECT result is then formatted according to any format commands executed earlier in the session.
To reinstate Unformat mode, execute:
SET FORMAT OFF;
Subsequent results are then unformatted, as described above.
Certain format commands, discussed in Chapter 6, may also be applied to an unformatted result.