17.10 - PRINT variable - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

The PRINT variable command displays the value of specified variables.


{ PRINT | PR } variable [;...]

Syntax Elements

Variable whose value is to be displayed.
The value is displayed in the form of an assignment command for that variable.
Some variables that can be changed with ctl do not appear on any of the ctl output screens. To see a listing of all variable names, use the print all command.

Example: Displaying the values of specified ctl fields

For example, if you type the following two variables

> print minimum node action;fsg cache percent

then the following might be displayed, depending on your system:

Minimum Node Action=Clique-Down
FSG cache Percent=80