Basic Teradata Query (BTEQ) Language is a general-purpose, command-based tool that enables you to communicate with one or more Teradata Databases. BTEQ provides a batch or interactive interface that allows you to submit SQL statements, import and export data, and generate reports. BTEQ provides report formatting and routing options for queries. BTEQ can also be used to import and export data between your client and database tables.
A BTEQ session provides a quick and easy way to access a Teradata RDBMS. In a BTEQ session, you can do the following:
• enter Teradata SQL statements to view, add, modify, and delete data.
• enter BTEQ commands.
• enter operating system (VM, MVS, DOS) commands.
• create and use Teradata stored procedures from a BTEQ session.
Comments