Normally, the result of a SELECT statement does not exceed the size of the display area of your terminal screen. Sometimes, however, the displayed result of a statement or macro exceeds the length or width of the display area. When this happens, ITEQ formats the lengthy result into pages corresponding to the size of the display area.
Until you discard a result, you may view it at your terminal or file it for later use. The result also may be formatted and printed as a report, as discussed in Chapter 6.
When you enter a new SELECT statement or a macro containing a SELECT statement, the result of any previous statement is automatically discarded. Executing a CANCEL command also deletes the result of the present query.