Blogging on Teradata SQL and More
I thought, its been a few days since I blogged something but when I look back, 2 years have passed. Time flies, like Jet or Super Sonic. As because it does not stop, it speeds faster than everything. Well, not all will agree with me but truth is that, Tortoise had won the race.
So this [...]
Popularity: 6% [?]
So, this is New Year. Seems like the year 2007 has just begun and moved ahead in First Forward mode throughout and today it is going to be a history soon. This is “Time”, one of the rarest things that can not be bought at discount but always available at par and we almost always [...]
Popularity: 45% [?]
Using Extract function with any date field is easy. Let’s try this out with system date and system time commands. To see the current date we use
SELECT DATE;
This would give output as “11/06/2007″. Suppose you want to EXTRACT the month from the date then use this query
SELECT EXTRACT (MONTH FROM date);
This would give “11″ as [...]
Popularity: 63% [?]
I have been using WordPress since sometime and it is been smooth so far. This is my fist posting about WordPress and guess it would be useful one. Here is the synopsis, today I wanted to post an article on page, which is not the default homepage and also not the static page but it is something like a category [...]
Popularity: 58% [?]
A macro is created to execute a single or a set of SQL statements in a single execution. Each time the macro is run all of the SQL statements present inside the macro are executed and results are returned after the end of all the SQL present inside the macro.
Why do we need a macro? [...]
Popularity: 65% [?]
When you want the column name of the table to appear differently in your SQL query, just to make sure that you too can do some magic, you can use aliases. Though aliases can also be created for various database objects like tables, views, stored procedures and macros, it is the column aliases that are [...]
Popularity: 55% [?]
A derived column is a result of a calculation (most of the time mathematical) that happens during the SQL query processing and generates a new column which is not part of the original table definition. For example, in our table we have salary column present but when we want to extract a percentage of the [...]
Popularity: 57% [?]
In this Section we are going to try out all possible simple SELECT queries. First lets create a sample table called emp which should have rows like the following.
emp_no
dept_no
first_name
last_name
salary
7000
114
Read
Vitamin
62,000
4000
113
John
Row
55,000
5000
114
Robert
Howard
65,000
2000
112
Larry
King
60,000
1000
112
Philip
Josheph
65,000
6000
115
Tony
Peter
72,000
3000
111
Micheal
Reed
46,000
8000
113
Philip
Josheph
65,000
9000
115
Tony
Peter
72,000
1100
114
Micheal
Reed
46,000
Follow this command to create a [...]
Popularity: 76% [?]
The Teradata system comprises of several interconnected software and hardware which intercommunicate within each other to bring out the best of Teradata as a whole. Following are the main components in the Teradata system.
Call Level Interface (CLI)
Data Communications Manager or Teradata Director Program (TDP)
Parser and Dispatcher or Parsing Engine (PE)
Interprocessor Network (BYNET)
Database Manager or Access [...]
Popularity: 75% [?]
The principle objective of a transaction is to facilitate data completeness when a sequence of events happens. Although it is not necessary that a “sequence of events” has to take place. A single event can also be considered as a transaction. A single event could be any data manipulation events like INSERTING, UPDATING or DELETING [...]
Popularity: 49% [?]
