Like Mondays, Friday does not come very fast but it does goes away in a blink of an eye and as usually, we get one more excuse to feel sleepy during the next Monday. Frankly speaking, even I am one among you and sometime I go beyond the expectation by taking the entire Monday off. [...]

Popularity: 12% [?]

If you are user of “sqlplus” in Oracle then surely you would glad to know the equivalent tool available in Teradata is; Basic Teradata Query, more famous as BTEQ. Just like sqlplus it is a client tool that communicates with the Teradata Databases. It has its own set of commands that is helpful for setting/formatting [...]

Popularity: 18% [?]

In Life, certain things comes easy and free of cost, but takes away a whole lot of our savings in terms of health, finance, goodwill, hardwork  and more. One such startling subject is “Anger”. As you know there is a famous phrase goes as “Well Begun is Half Done”. And if you start anything with [...]

Popularity: 12% [?]

In Teradata not only we can display the totals and the sub totals but also we can show the details of the row(s) that goes into creating these totals. This can be achieved with the use of WITH and WITH…BY functions.Let’s understand this with the following example dataset.
Table Name – EMPLOYEE 

emp_no

dept_no
first_name
last_name
salary

7000
114
Read               
Vitamin            
62,000

4000
113
John                
Row                 [...]

Popularity: 20% [?]

There a couple of ways you can do this, one by using the function ‘COALESCE’ and the other one is using CASE expression.
COALESCE is a simple function which takes one or more column names and a replacement (default) value which can be displayed in case of the missing data.  For example, in an employee table [...]

Popularity: 50% [?]

This is a very common problem while displaying some numbers (numeric values) using the format function in Teradata. Instead of the numbers, you would see a bunch of wild char characters (‘*’); If you run the following SQL in Teradata SQL Assistant Version 7.1
SELECT cast ((545458874489 (format ‘999-999-9999′)) as char (15)) as Format_Cast_PhoneNum
Output would be [...]

Popularity: 19% [?]

There is no direct answer to this question as this concept is present and used only in Stored Procedures and Macros in Teradata. But there are ways to replicate this functionality in the command prompt.
As said before create a macro and pass a variable. Remember you can not use dynamic SQLs in a Macro. Also [...]

Popularity: 37% [?]

Putting ‘$’(Dollar) sign or ‘%’( Percent) sign is not a complex task as coming to a figure where you would like to have this prefixed or suffixed. So, first make sure the ground work is done.
If you are calculating a division on the fly and the numerator is greater than the denominator than there is [...]

Popularity: 24% [?]

After worked in Oracle databases for sometime, lately I got an opportunity to work in Teradata. As expected, I too was having difficulties in learning equivalent commands of Oracle in Teradata, which   specifically used on the command prompt. This need prompted me to draft a small reference sheet or call it ”Teradata Basics” which I use very [...]

Popularity: 33% [?]

Most of the time I used to think Amazon is the best place for books, definitely it is but not the chepeast one. If you have a habit of reading books and want to spend less money as I do, then you would be glad to know that there are some sites where there are [...]

Popularity: 12% [?]