Changing Screen Width - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

The default WIDTH setting accommodates a display of result lines comprised of a maximum of 75 characters for interactive use.

Note: Less characters might be displayed if non-Unicode multi-byte characters exist in the output.

If the terminal screen can display more than 75 characters, it is possible to increase the WIDTH setting. This can be of value when entering Teradata SELECT statements with more expressions than are viewable using the default setting. The valid range is from 20 to 65531.

Use the following BTEQ WIDTH command, for example, to change the value of the screen width specification to 120 characters:

   .SET WIDTH 120

If a screen width is specified that is smaller than 20 characters or larger than 65531 characters, BTEQ displays the following error message:

   ***  Error:  Width out of legal range of 20 to 65531.

For details, see “WIDTH” on page 353.