0 - 14 of 14 tags for teradata sql

Hi,
I am planning to write Teradata 14 certifications. Can any one suggest me which materials are good to study. I am planning to write first 3 exams in next month.  Please guide me if you know any good materials.
 
Thanks in advance
varna

This session is intended for those already familiar with writing SQL but who are somewhat new to Teradata.

Hi, can any one help me giving the code to this query?
 
I have a Customer table which have duplicate rows. In that table
I. I want only unique rows.
2. I want only Duplicate rows ( if in Table unique rows exist, i don't want them to display)
 
Thank you
Meena

Hi All,
 
I have requirement to filter the numeric characters from the combination of alphanumeric nad numeric records.
Example: i/p: V3456TY
                     V5678YU
                     9856
                     B903RT
                     235
                     M8900TU
 

Hi 
I have a date column in which the default low date is not  not aligning with other dates in the columns 
here is the screen shot . 

LAST PMT DATE

10/31/2009

8/2/2005

9/18/2009

12/26/2007

12/13/2006

3/15/2012

4/21/2009

11/9/2011

Hi,
In Sybase, you can use IF EXISTS to validate the existance of a table, if it exists, a set of statements should be executed inside the stored procedure.
What is the equivalent code in Teradata SQL Assistant ?

And what is the issue in using if exists in teradata?

Thanks in advance.

 

I have data  as follows in a Table ( 3 columns ):

Hello,
I'm facing a pretty strange issue here, wanted to see if anybody had any insight on this. 
I'm creating a TD table with a TIME(0) field in it. Strangely, once the CREATE TABLE is complete, the table is created with a INTEGER field instead.
Table Create SQL:

I have created a view with complex logic.
While I am trying to select that view.I am getting the error mentioned in the subject.
FYI.
The logic doesnt contain any IN keyword...
 
Looks strange.
 
Could anyone help in this regard?
Thanks in advance
KVB

Hi All,

Please help me through this

sel

a.col1,

a.co2,

a.col3,.........b.col1,b.col2..,c.col1,c.col2

from table1 as a inner join table2 as b on a.col1 =b.col1

inner join table 3 as c on a.col1 = b.col1

where col1 = xxxxx;

All,

As you know, Teradata handles ANSI-SQL as standard but also supports various Teradata SQL extensions to the ANSI-SQL, like EXPLAIN, SHOW, HELP, COLLECT STATS, etc...

Would there be a complete list of these Teradata SQL extensions anywhere?  If anyone has one, that'd be great.  If they have explanations, that'd be even greater.

Hi all,

There is the following query in Oracle fetching 11 rows. In Teradata this sql gives error with the message ' SELECT Failed: 3706: Syntax error: expected something between '+' and ')'.

Anyone could share how this query could be translated into Teradata syntax please. I searched and tried some but not successful. Will appreciate your help.

SELECT DISTINCT C.CLASS2ID , C.DESCRIPTION
FROM CLASS2 C, PRODUCT P, PRODUCT_LOCATION PDL
WHERE
P.CLASS1ID = C.CLASS1ID
AND C.CLASS1ID = '00009'
AND PDL.LOCATIONTYPE (+) = 'S00002'

AND PDL.LOCATIONID (+) = 'S00002'

This book provides information about Teradata Parallel Data Pump (TPump), a data loading utility that helps you maintain (update, delete, insert, and atomic upsert) the data in your Teradata Database. TPump uses standard Teradata SQL to achieve moderate to high data-loading rates.