CNSSET LINES - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Sets the number of lines that are saved from the output display area and sent to DBW after a reconnect with CNS.

Syntax

CNSGET LINES n
n
number of lines to be saved.
Valid values range from 2 to 72 lines.
The default is 10 lines.

Usage Notes

Teradata recommends setting large values (for example, 10 or more lines), unless the display of old input and output after a reconnect is a security concern.

To check the current number of lines set, issue the CNSGET command. For more information, see CNSGET.

Example: Setting the number of lines to be saved from the DBW display

In this example, the number of lines set to be queued on the system is 12.

cnsset lines 12

CNSSUPV: cns will save 12 lines per screen.