Thursday 14 February 2013

39. What is BTEQ ?

Basic Teradata Query (BTEQ) is a Teradata SQL tool.

BTEQ is one of several front-end utilities for submitting SQL to the Teradata


BTEQ is Teradata client software that is installed on mainframe hosts or
network-attached clients. It operates under all host systems and local area
networks (LANs).

BTEQ contains additional commands for report formatting.

BTEQ commands:

· 
Must be preceded by a period mark (.).

·
Provide an output listing (an audit trail) of what occurred.

·
May use the semicolon (;) following them.


BTEQ can be used as either an interactive or batch utility.
Starting BTEQ

To start BTEQ at a UNIX workstation or node that has the BTEQ utility
installed, type
bteq at the UNIX command line:
#bteq

No comments:

Post a Comment