17.10 - Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

To start ctl from the command line, use the following command syntax:

ctl { command_spec [...] | -help }
command_spec
{ -first | -last } { command [;...] | "command [;...]" }

Syntax Elements

-help
Provides information on ctl command-line options.
-first
First command or commands to run before other processing.

No default.

Example:

ctl -first “Node Logging Rate = 600;screen rss; write; quit”

Sets the RSS screen Node Logging Rate field to 600, displays the RSS screen to confirm the changes, writes the changes to the Control GDO, and quits the ctl utility.

-last
Last command or commands to run just before exiting.

No default.

Example:

ctl -last screen

Displays the current screen before exiting the ctl interactive mode.

command
Command from Ctl Commands.
If any command includes blank spaces, enclose the command list in double quotation marks.
Teradata recommends using the full field names, rather than the alphanumeric field identifiers in command lists for the -first and -last options.