Error message

User error: Failed to connect to memcache server: rpc4010:11222 in dmemcache_object() (line 415 of /appl2/devx/drupal/sites7/all/modules/memcache/dmemcache.inc).
All Forums

Topics related to the Teradata Database, excluding database connectivity (e.g. JDBC) and extensibility (e.g. UDFs) . Typical topics are about SQL syntax and usage (SELECT, GROUP BY etc), database performance, use of database functions, comparison with / migration from Oracle or DB2, and generally why the Teradata Database rocks. For articles, blogs and more, see the Database section of the site.

You must login to post to the forums.
Temporals and Outer Joins Topic by SANJI 09 May 2011 temporal validtime inner join left outer join

One of the caveats (if i may say so) of temporals is that apart from inner joins, you DO NOT have the liberty of doing anything with it...ofcourse outside the scope of usual temporal commands. For instance, you can't do an outer join or a UNION or an EXISTS etc

Now, this definitely doesn't mean that one should stop considering temporals, infact i believe that temporals would be and is a quite a game changing phenomenon for Teradata. It's an absolute charm as a concept.

4093 views
6 replies, 2 hours ago
what is the significance of FORMAT in table DDL, what if we dont give any format ? Topic by sreedhar26 19 hours ago

Hi guys,
we are planning to migrate our warehouse from greenplum to TD, so our DBA suggested to create the table DDL as below:
 
Sourece DB(in GP)                                          
create table XXX(                                                                 
col1 bigint NOT NULL,
col2 character varying(1),
col3 character varying(200)

35 views
1 reply, 18 hours ago
Calculation Precision issue Oracle Vs Teradata Topic by ankitk 1 day ago Round, precision, decimal, oracle, teradata

Hi Team 

 

While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.

 

-- Oracle

SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual

--0.000

 

 

-- Teradata

57 views
2 replies, 22 hours ago
Calculation Precision issue Oracle Vs Teradata Topic by ankitk 1 day ago Round, precision, decimal, oracle, teradata

Hi Team 

 

While performing calculations I am facing some precision issues between output from Oracle and Teradata.Please Help.

 

-- Oracle

SELECT ROUND((((3.82/23.88)*23.88)/767),2) FROM dual

--0.000

 

 

-- Teradata

19 views
0 replies
does Teradata support UTF-16 surrogate pair? Topic by Jeenphy 1 day ago

Environment:
  Teradata DB 15
  Executing below SQL statement
        select _UNICODE 'd835dc01'XC ;
  I got error " *** Failure 5356 One of the characters or code point does not exist within the specified repertoire."
The same error is seen both from bteq and from Teradata Studio, with session charset UTF16 or UTF8. Could somebody confirm if below things:

33 views
1 reply, 1 day ago
SQL query to understand the names of all the available tables in the database , number of records for all these tables and s Topic by krishnaprasadmt 2 days ago

Hi

Please help me with a SQL query to understand the names of all the available tables in the database , number of records for all these tables and size of all these tables ?

Regards,
Prasad

102 views
4 replies, 1 day ago
Locking on DBC.All Topic by Kishore_1 2 days ago DBC.All

User X is blocked by another user Y as user Y is holding a WRITE lock on table DBC.All
What is the DBC.All table?When is it used?what is the write operation that is being performed by the user session?
(Tried using show table/view DBC.ALL ,but encountered error).
 
Appreciate your help!!
Thanks

48 views
1 reply, 1 day ago
TERADATA Regular Expression Function Topic by Jugalkishorebhatt1 5 days ago TERADATA Regular Expression Function

Hello All,
In the info.teradata.com, which document can i find regular expression Function.
 
 
Thanks
Jugal

93 views
2 replies, 2 days ago
Copy the record and increment in its one column Topic by Lacsum 3 days ago teradata, increment column, Identity column, csum, olap, rank, rowcount, max number

Hi, 
So i've been searching all around on how i could increment a column in Teradata. I'm new to this so im not really familiar with all the syntax or tactics that i could use. 
I've read about autogenerated identity column, OLAP and recursive in teradata but i think it does not matches my need. 
So here's my problem.

84 views
3 replies, 2 days ago
My perception on EXPLAIN was wrong Topic by cheeli 3 days ago explain

Greetings experts,

48 views
1 reply, 3 days ago
String contains an untranslatable character Topic by cheeli 3 days ago untranslatable character

Greetings Experts,
I need to find out what are the columns that has any language characters other than english (unicode with other language characters in it - not dbc.columns.chartype=2)  Teradata version: 13.10
eg: tablea=> cola => unicode => the data in it is in chinese
      tableb=> colb => unicode => the data is it is in english

37 views
0 replies
Format with leading zeros Topic by Alex181 3 days ago

Hi, I need to format the column accnt_id to get the output as result_accnt_id. Any help will be greatly appreciated. Thanks.
 
accnt_id     Result_accnt_id
1               A0000001
2               A0000002
39,000       A0039000
100,962     A0100962
 

148 views
6 replies, 3 days ago
regexp_replace woes Topic by jnevill 01 Nov 2013 regex, regexp_replace, replace, translate, omgwtfbbq

I want to replace all of the whitespace and non alphanumeric characters in a string. It seems like some form of the following should work:

1564 views
7 replies, 3 days ago
What's the difference between NOT IN and minus in SQL? Topic by lijianguonew 3 days ago teradata

Hello Experts:

 

What's the difference between NOT IN and minus  in SQL? 

 

Which is better to use in SQL queries for the performance aspects?

82 views
1 reply, 3 days ago
Setting Spool Space Limit for Profiles Topic by Kishore_1 3 days ago spool space, profiles

We are having ~1000 Business Users, who are accessing the Teradata Production system.

The business users are assigned to a common profile.We want to set a spool space limit for the business users at profile level.

How can we get the value of spool space that will enable the buiness user's queries to run smoothly.

38 views
0 replies
QUERY CHALLENGE - FIND CUSTOMERS WHO HAVE SPECIFIC PRODUCTS Topic by CCSlice 4 days ago

Hi Everyone
 
 I am trying to find a way to return client no's that exclusively have a product(s).  Let's say the product numbers are 1 and 2.   They customer can either have product_id 1 or product_id 2 or both.  Now the problem is that many customers may either of these products but also other products.  These customers have to be excluded.

84 views
3 replies, 3 days ago
CASE Statement error please help Topic by nileshbhaw 4 days ago

Hi All,
 
While running the below query it gives me error ' Illegal expression in WHEN clause of CASE expression' . Can you please tell me what is wrong with the below code.
 
 

SEL A.*,

CASE WHEN CUST_NM = CC_Lookup and CUST_NM is not null then 

74 views
3 replies, 3 days ago
How to configure a scheduler in teradata? Topic by shivasha 4 days ago scheduler

Is there is any system table available in Teradata to hold scheduler information?
I am using weblogic server with Teradata.
Need to run in clustering mode.

45 views
1 reply, 3 days ago
Calling Stored Procedures from Dynamic SQL Statement Topic by thomas.wolf 5 days ago

Hi,
is there a way to call a stored procedure from a dynamic SQL statement? I don't know the name of the stored procedure at compile time, so I have to build the SQL command invoking the SP dynamically.
Thank you in advance,
Thomas

91 views
3 replies, 4 days ago
ROLLING 12 MONTHS Topic by cmyeyez 1 week ago

Hi.
I need the syntax to create a table or view for 12rolling months
using the system calendar (syscal).
using Teradata 13.11
 
Thanks

148 views
7 replies, 4 days ago
SQL query to understand the names of the tables , number of records in a table and size of the table Topic by krishnaprasadmt 4 days ago

Hi
Please help me with a  SQL query to understand the names of the tables , number of records in a table and size of the table ?
 
Regards,
Prasad

75 views
2 replies, 4 days ago
To find number of null values in each columns of a table Topic by jayantarout79 1 week ago count null values

Hi ,
I want to count all the null values of all the columns of a table.
SEL ColumnName  from  DBC.Columns where tablename='table_name' and DatabaseName='database_name';
The above will provide all the column names.
SEL COUNT(*)-count(col_name) from table_name;
The above will provide number of null values for one single column.

170 views
6 replies, 5 days ago
Identifying GTT or volatile tables created during a session Topic by Moutusi 5 days ago #Volatile tables, global temporary table

How can I identify what are the GTT or volatile tables created during a session?

64 views
2 replies, 5 days ago
Cursor in Dynamic SQL Topic by Sun_shine_jgd 3 weeks ago cursor processing teradata stored procedures

Hi i have a cursor which returns me the date.
Belwo is the sample

FOR Cur_Dt AS Cur CURSOR FOR

SELECT STRT_DT

FROM table

WHERE STRT_DT

BETWEEN 1900 -01  01

AND 9999 01  01

 

Now i have a dynamic SQL..

92 views
2 replies, 5 days ago
Defining two derived tables using WITH clause ?? Topic by mjasrotia 20 Mar 2012

Following is a way to define a derived table using a WITH clause in the starting of the query and using it in the query thereafter. Is there a way to define more than one derived tables using WITH clause.

 

I understand the use of VT, GT and other temp tables but still need to know if there is a way to do that using WITH clause.

 

WITH TEMP_TAB(a,b,c)

8855 views
10 replies, 6 days ago

Pages