Basic TEradata Query utility is one of the advantages of Teradata over other extraction utilities. The advantage of the BTEQ utility is its error handling ability and conditional execution. It is more common that the query execution is often compared against the conditional flow in programming languages and programmers may end up choosing JDBC connection… Read More »
Batch Teradata Query(BTEQ) is a powerful utility in Teradata with multiple options. You can export/import tables and files and make use of them in the same sessions for checking conditions to take decisions. Based on the checks, you can perform your DDL, DML operations. In this post, we will use a very simple use case… Read More »
In the other post, we saw how to create tables in Teradata and the corresponding examples for each. Here we will see how to create a table with select from another table. In this post, we will see how we can create a table using select in Teradata. There are different ways in which we… Read More »
There are different ways to create tables in Teradata. We can also define the tables so that they will allow or not allow duplicates. We can also create tables with data from another table on the fly. Create table – Default We can create a table in Teradata with the default options By default, if… Read More »
In this post, we will see how we can connect to Teradata using the JDBC connection in Java using the credentials and copy the contents of the table to a CSV file. JDBC stands for Java Database Connector which is nothing but a set of libraries that will have supported functions to communicate with Teradata… Read More »
BTEQ stands for Batch Teradata Query. It is one of the utilities in Teradata to perform DDL and DML queries, creating macros, etc. However, the BTEQ export feature is exclusively for exporting the result of a query to a file. BTEQ modes There are two modes of running BTEQ. They are interactive mode and Batch… Read More »