You set Format mode by entering the “SET FORMAT;” command while in Unformat mode. If you have not set any format specifications during a session, a query result in Format mode is displayed according to ITEQ-defined (“default”) format specifications.
Let’s assume that you have entered the following statement in Format mode:
SELECT DeptNo, Name, Salary FROM Employee
WHERE DeptNo IN (100, 700)
ORDER BY Name;
The processing message for the statement result:
QUERY COMPLETED. 7 RECORDS FOUND.
3 COLUMNS RETURNED.
MAXIMUM LINE WIDTH IS 32 CHARACTERS.
appears by itself as the first result page. Enter the “FORWARD;” command and the first page of the result is displayed (Figure 10).
Figure 10: First Page ResultBecause you have not yet set your own format specifications, this result is displayed according to the default format settings. The default format is as follows:
You can specify an insertion character instead of a blank, as discussed later in this section.
Displayed pages are formatted to the size of the display area.
When displayed, a default-format result appears left-justified; that is, aligned on the left-hand side of the screen. The result heading conforms to the size of the screen, with the date left‑justified, the title centered, and the page number right‑justified. A result that is wider than the display screen is viewed using the LEFT and RIGHT display commands (see Chapter 5).