Command-Line Invocation | Basic Teradata Query - Command-Line Invocation - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

BTEQ is a command-line interface utility. It does not provide graphical or menu-driven controls. Users must provide text-based instruction input either interactively or with use of batch mode scripting. To be invoked, the command "BTEQ" must be issued.

For example, to run Windows BTEQ interactively, enter the word "BTEQ" at the system prompt. An initial long-form prompt for input will be generated that shows the specific BTEQ version and flavor, the process id for the BTEQ session, copyright notice and a suggested next action.

Teradata BTEQ 17.00.00.00 (64-bit) for WIN64. PID: 35920
Copyright 1984-2020 Teradata. All rights reserved.
Enter your logon or BTEQ command:

To control the way BTEQ behaves, users are provided with a set of commands. For workstation BTEQ, a set of options is also provided. To use an option, it must be specified as part of the invoking BTEQ command's syntax.

For example, to specify the Windows BTEQ is to only print out its version number and then immediately end its process, the -Vs command line option can be used.

C:\>bteq -Vs

To be accepted, the 'V' must be uppercase. BTEQ responds by generating the version value text and silently exiting.

17.00.00.00