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

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
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 20.00.00.03 (64-bit) for WIN64. PID: 10564
Copyright 1984-2024 Teradata. All rights reserved.
Enter your logon, BTEQ command or .h for help:

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