Jump to content

BTEQ

Add links
From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Vanished user 3208088 (talk | contribs) at 10:27, 9 March 2007 (Added {{Advert}}). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

BTEQ is a Teradata utility. BTEQ stands for Basic Teradata Query Utility

BTEQ – SQL Query Capability

BTEQ, available as part of the Teradata Utility Pack, is a general-purpose, command-based tool that enables you to communicate with one or more Teradata Databases. BTEQ provides an interactive or batch interface that allows you to submit SQL statements, import and export data, and generate reports. BTEQ provides report-formatting options where queried data is formatted and returned to the screen, file, or printer. Scripts are sent from the client to the Teradata Database where the actual process occurs. You can also use BTEQ to import and export data between your client and database tables. BTEQ’s streamed package format design ensures fast processing and effective resource utilization.

Features

  • Report formatting
  • Ad hoc query tool
  • Database administration
  • Best for small data volumes

Definition

BTEQ is an abbreviation of Basic Teradata Query. It is a general-purpose, command-based program that allows users on a workstation to communicate with one or more Teradata RDBMS systems, and to format reports for both print and screen output. Using BTEQ you can submit SQL queries to the Teradata RDBMS. BTEQ formats the results and returns them to the screen, a file, or to a designated printer.

Supported Platforms

See also

Retrieved from "https://en.wikipedia.org/w/index.php?title=BTEQ&oldid=113803390"