Using Format Default - Interactive Teradata Query Facility

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).