Teradata SQL Assistant - Tips & Settings

There are various options available in TERADATA SQL Assistant which may make your life lot more comfortable. The only thing which stops you is lack of knowledge how these options can help. Below are few tips & tricks for Teradata SQL Assistant: a) EXPLORER TREE: Explorer Tree is very useful and least used by most of the people working on Teradata SQL Assistant. I prefer having Explorer Tree enable all the time as it can save huge number of man hours. To enable EXPLORER TREE, go to VIEW –> EXPLORER TREE Once it is enabled, you can see it on left pane. Now Right ClickRead More →

Teradata SQL Assistant - Import Data

Importing Data from FLAT FILE to TABLE using TERADATA SQL ASSISTANT is very simple.It is very easy to import data from any flat file to table in TERADATA using TERADATA SQL Assistant. First, you need to write SQL Query in Query Window. INSERT query should be in accordance with the flat file considering the columns mentioned in FLAT FILE in the same order. So if your flat file contains five columns, mention those five columns in the same order in your INSERT CLAUSE; like INSERT INTO TABLENAME (COL1,COL2,COL3,COL4,COL5) VALUES (?,?,?,?,?); Go to FILE –> Import Results. Now when you run the query, it will displayRead More →

Teradata SQL Assistant - Export Data

Exporting Data from Table to FLAT FILE using TERADATA SQL ASSISTANT is very simple. It is very easy to export data from any table in TERADATA using TERADATA SQL Assistant. First, you need to write SQL Query in Query Window. The output of this query you want in flat file. Go to FILE –> Export Results. Now when you run the query, it will display the browse window and will ask you to name the file in which output of the query will be re-directed. SELECT COL1,COL2,COL3,COALESCE(COL4,0),COL5 from TABLENAME; Points to consider while exporting data from table: a) Delimiter: Whether you want file to be FIXEDRead More →

Teradata SQL Assistant - DEFINE DATA SOURCE

Teradata SQL Assistant is the SQL Editor which is most widely used to execute SQL queries on Teradata. The Teradata SQL Assistant has very easy to use GUI and it is far more comfortable to work on this editor than working on any other SQL Editor for Teradata. Teradata SQL Assistant has almost all the functionality which can be achieved via BTEQ. The first step after opening Teradata SQL Assistant must be defining a data source. Teradata SQL Assistant can be used to connect to any RDBMS that supports ODBC connection. To connect to a Teradata RDBMS , lets DEFINE DATA SOURCE first. Go to TOOLS –>Read More →