How to Change Screen Width | Basic Teradata Query - Changing Screen Width - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

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

Fewer characters might be displayed if non-Unicode multibyte 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 using SQL requests that return larger sized column values or rows than are viewable using the default setting. The valid range is from 20 to 1048575.

Example – WIDTH

Use the following BTEQ WIDTH command to change 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 1048575 characters, BTEQ displays the following error message:

***  Error:  Width value must be in the 20..1048575 range.