Basic Teradata Query (BTEQ) software is a general-purpose, command-based program that allows users on a workstation or mainframe to communicate with one or more Teradata Database systems and to format reports for both print and screen output.
Using BTEQ you can submit SQL queries to the Teradata Database. BTEQ formats the results and returns them to the screen, to a file, or to a designated printer.
A BTEQ session provides a quick and easy way to access a Teradata Database. In a BTEQ session, you can:
- Establish one or more Teradata Database sessions to submit single- and multistatement SQL requests using either Teradata Mode or ANSI standard transaction semantics.
- Use Teradata SQL statements to view, add, modify, and delete data.
- Use formatting commands to produce Field Mode based columnar reports.
- Specify operating system commands.
- Create database objects, such as user-defined functions and stored procedures, that require transfer of source files.
- Submit interactive as well as scripted input instructions.
- Invoke BTEQ as a subprocess by languages such as Java and Python.