Syntax - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

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

ctl { command_spec [...] | -help }
command_spec
{ -first | -last } { command | "command [;...]" }
-first command
First command 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 command
Last command to run just before exiting.

No default.

Example:

ctl -last screen

Displays the current screen before exiting the ctl interactive mode.

-help
Provides information on ctl command-line options.
Some strictly internal and rarely-needed options have been omitted from this discussion. Those options are documented in the ctl command-line help.