Answer / rajkumar

Chinna,you copied vinay sir answer here but that is not the
answer for the question.He is asking v2r5 and td12
differences.
madhu,I will copy vinay sir answer here tomorrow.

Answer / vinay sir (teradata trainer) h

Hi All,
I am posting a very detailed answer for Teradata Version
differences.you can refer it.

TERADATA VERSION DIFFERENCES
V2R5 New Features and Eliminated Features
1. Added Identity column features to implement Primary key
and Unique key concepts.
2. Statistics can be collected on
a. Multiple Non Indexed columns of a table.
b. Using sampling data from a table.
3.Partition Primary Indexed Added and types described.
3. Materialized View concept provided through
a. Partialy covered join Index.
b. Sparse Join Index.
4. Stored procedure features like
a. Implementing Cursors using declare cursor statements.
b. Altering a Procedure Using Nested computed statements.
c. FETCH to get the rows one by one sequentially.
d. Get help information on Stored Procedure and
Attributes etc.
5. Multi Column Compression for Table Columns.
6. Setting the default DATEFORM form Options.
7. Implementing Multiple Distinct Aggregations in a Select
Query etc.
V2R5.1 Features
1. ANSI Triggers Introduced.
2.Row Triggers, statement triggers are supported.
3. It allows Recursion and Aggregation inside Triggers.
4. Stored Procedure Enhancement achieved
Implemented different recompilation methods of a stored
procedure.
5. Recognised requirements for running C compilers in the
Teradata UNIX Environment.
6. Provided more Contextual Information for Internal Error 5547.
7. Large Objects supported.
a. we can load and unload large objects even in
BTEQ(BLOB,CLOB)
By Using LargeDatamode.
8. User Defined Functions Added.
Note:
1. we cannot write Print Statement inside Procedure.
2. Stored Procedures Created in V2R5.1 require Recompilation.
V2R6 FEATURES
1. Queue Tables are added.
2. Triggered Stored Procedure added.
3. Stored Procedure Grammar Merge added.
4. Multi statements request submitted (supported in stored
procedures by using
BEGIN REQUEST
------
END RESQUEST.
5. External Stored Procedures (xSP added).
6. BLOB’s are supported by stored procedure and External
stored procedure.
V2R6.1 FEATURES
1. Stored Procedure OUT Parameter Changes.
2. PPI on Volatile and Global temporary tables.
3. User Defined types Added (UTDs)
4. PPI on Join Index added.

V2R6.2 FEATURES
1. Alter Table column Compression added.
2.'CREATE TABLE AS WITH STATISTICS ' ADDED.
3. Auto generated key Retrieval added.
TD 12 FEATURES
1. Stored Procedure Enhancements
a. Retrieval of one or more results set from a stored
procedure.
2. Error Tables Added with external syntax.
3. TERADATA 12 Provides complex error handling capabilities
in conjunction with a
MERGE INTO (or) INSERT SELECT statements accomplished
through the Usage of new SQL
based error tables.
4. Usage of ANSI Merge Operation at the time of loading added.
5. Compare and contrast the advantage of Merge instead of
MULTILOAD.
6. TD 12 MERGE plan is different from V2R5 MERGE plan.
7. Multilevel Partitioning provided.
8. Added many changes to the User defined functions and
Table functions.
9. Supports SQL Invocation Using External Stored Procedures.
10. Teradata Extended Support for Windows Aggregate Function.
example
STDDEV_SAMP[standard deviation sample]
CORR ---Corelation
COVAR_SAMP (Corelation Variable sample )
VAR_SAMP etc.
11. It supports DSW of 20 bits also.
12. BLOB and CLOB Extended till 10 GB.

If you want more and more detailed points you can drop me a
mail to my id teradatavinay@yahoo.co.in

Moreover I am adding one more valid information my students
are maintaining a blog you can find more stuffs in this path

http://teradatavinay.blogspot.com/


Thanks & Regards
Vinay Sir (Teradata Trainer ,Hyderabad)

Answer / chinna

In Teradata13 Added 93 New Features and While Improves the
performance more tan 30% The query.Teradata Viewpoint
Provides A Suite of Web Based Applications That enable you
to monitor and manage Teradata DataBase system Permance
From Any where using Standard Browser
1.Added NOPI
2.STORAGE LEVEL
3.PORTLETS
4.GEO SPATIAL SUPPORT
5.TERADATA MULTISYSTEM MANAGER
6.MAINLY DESIGNED FOR (a)DATA MART APPLIANCE
(b)EXTREM DATA APPLIANCE
(c)DATA WAREHOUSE APPLIANCE
(d)ENTERPRICE DATAWAREHOUSE
7.NOPI

what are the default access rights in the teradata?

1 Answers  

---

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

2 Answers   IBM, Wipro,

---

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

---

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,

---

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  

---

How do you create a table with an existing structure of another table with data and with no data?

1 Answers  

---

Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,

---

teradata support to automatically increase the character length or not?

1 Answers  

---

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

0 Answers  

---

What is a sparse index?

0 Answers  

---

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

2 Answers  

---