15.00 - Using Format Default - Interactive Teradata Query Facility

Interactive Teradata Query User Guide

prodname
Interactive Teradata Query Facility
vrm_release
15.00
category
User Guide
featnum
B035-2452-034K

Using Format Default

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 Result

Because 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:

  • A report heading that consists of one line containing: the current date, a title made up of the first 60 characters of the Teradata SQL request, and a page number preceded by the word PAGE.
  • Blanks in place of null values.
  • You can specify an insertion character instead of a blank, as discussed later in this section.

  • Non-suppressed repeating values (for example, in the DeptNo column).
  • A page length of 55 lines for a printed page.
  • Displayed pages are formatted to the size of the display area.

  • A maximum print line width of 132 characters.
  • 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).