What is basic teradata query language?

Questions by radhashyam_k

Showing Answers 1 - 6 of 6 Answers


  • Aug 1st, 2007

BTEQ(Basic teradata query)

It allows us to write SQL statements along with BTEQ commands. We can use BTEQ for importing,exporting and reporting purposes.

The commands start with a (.) dot  and can be terminated by using (;), it is not mandatory to use (;). SQL statements doesnt start with a dot , but (;) is compulsary to terminate the SQL statement.

BTEQ will assume any thing written with out a dot as a sql statement and requires a (;) to terminate it.

Here ,BTEQ is mainly suitable for Small tables and we can  perform any arithmetic operations in a query like computations using Funtions and INSERT WITH SELECT combinations all we can do that.

  Was this answer useful?  Yes


  • Sep 29th, 2009

BTEQ is a variant of the core set of ANSI SQL, with proprietary 'extensions' that are specific to Teradata databases only.

Similar to PL/SQL for Oracle, or T-SQL for Microsoft SQL Server, BTEQ includes the ability to perform database-vendor-specific instructions that are particular to Teradata.

Examples of database-vendor-specific instructions would include any sort of OBJECT  DEFINITION or PRIVILEGE statements.  The reason for this is that each database vendor maintains distinctly different, and patented, code for manipulating things that have to do with the tangible structure of their databases.  If such tangible differences did not exist, then the actual database products would be identical, meaning that someone would be infringing on someone else's patent.

  Was this answer useful?  Yes


  • Jul 30th, 2012

hello readers
it is just like sql assistance, but giving better performance then sql assistance, bteq work in from host (cli) where as sql runs from odbc so it having lot more opses (gateway) so gives some what less then bteq.

  Was this answer useful?  Yes

Basic Teradata Query Language or Batch Teradata Query Language is one of the effective utility in teradata. As using BTEQ we can write SQL statements in Interactive as well as Batch modes. using Bteq you can also Import Export data. Although for Importing and Exporting you have other utilities.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions