Syntax - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.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 [;...]" }

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.