269 | 05 Dec 2013 @ 05:55 PST | Database | Reply | MVC generated out of V14.00 statistics | Hi Roland,
Thank you for sharing your work, It would be great if you share your thaughts in a blog in Developer Exchange.
Good Luck!
|
268 | 05 Dec 2013 @ 04:45 PST | Database | Reply | recursive table | Bikky,
As you do not have any other condition except the join condition. on the basis of information you provided, I belive you should add WHERE LEVL<10 to avoid any unexpected recursion.
&nbs... |
267 | 05 Dec 2013 @ 04:41 PST | Database | Reply | Distinct Logic | Hi Bikky,
Hope the following query will dolve your problem, Or at least give you a start.
CT TD3471.table1(name1 VARCHAR(10),name2 VARCHAR(10));
INS INTO TD3471.table1 VALUES('ABC',... |
266 | 05 Dec 2013 @ 03:57 PST | Database | Reply | Whom can help me explain the ‘46.06:18:08’ time. | Hi gerado,
This query is not working for me, Have you tested it on your machine?
|
265 | 05 Dec 2013 @ 12:23 PST | Database | Reply | recursive table | Hi Bikky,
I am not sure what data do you have in in Merge_T table. Because it will depend on your data whether the recursion will stop after testing the condition and stop at some point, or it goe... |
264 | 04 Dec 2013 @ 10:27 PST | Database | Reply | Why I do not see all the databases in Teradata Studio | So you are using JDBC with LDAP?
I have tried changing the authentication mechanism to LDAP, and it is much of the same.
I think it might be the issue with user you are using, if you are on... |
263 | 04 Dec 2013 @ 09:56 PST | Database | Reply | Whom can help me explain the ‘46.06:18:08’ time. | Hi,
There are several options available in ODBC for how to treat date and time, like III, AAA etc, I tried them as well but it didn't worked.
But its always good to use time and date da... |
262 | 04 Dec 2013 @ 09:53 PST | UDA | Reply | Teradata Appliance 2500 series | Thanks gryback :)
|
261 | 04 Dec 2013 @ 09:50 PST | Database | Reply | Why I do not see all the databases in Teradata Studio | No, You do not have to create connection for each schema, But it is possible while making a connection you had specified some default schema, and then only that schema is visible in you database ex... |
260 | 04 Dec 2013 @ 05:23 PST | Database | Reply | Whom can help me explain the ‘46.06:18:08’ time. | Hi,
as gerado has explained that even with a format the underlying data type do not change and the resulting arithmatic is simple INTEGER arithmatic not the Time arithmatic.
You can use the... |
259 | 04 Dec 2013 @ 04:06 PST | Data Modeling | Reply | Delete Partition Vs Drop Partition? | Raja,
Thank you very much for the reponse, I am able to understand it to some extent.
It would be great if you can paste the queries.
|
258 | 04 Dec 2013 @ 03:59 PST | Database | Reply | Whom can help me explain the ‘46.06:18:08’ time. | Hi gerado,
I agree with you to some extent, But convertin this to time is not solving the issue, Can you please try the following queries:
--Converting literals to time
SELECT CAST( '11:10... |
257 | 03 Dec 2013 @ 11:42 PST | General | Reply | Does Teradata move all columns of a table to Spool | One more thing I forgot to add:
Teradata determines the smaller table by multiplying the number of qualifying rows with the number of bytes in column to be projected.
Smaller table size: Number o... |
256 | 03 Dec 2013 @ 11:38 PST | General | Reply | Does Teradata move all columns of a table to Spool | Raj,
A very interesting question. As you know, Teradata got a fantastic optimizer. This optimizer do a lot of things to make sure the use of minimal system resources (CPU, Memmory, Spool etc) and ... |
255 | 03 Dec 2013 @ 11:17 PST | General | Reply | Teradata seminars and events | Raja,
You are always welcome :)
|
254 | 03 Dec 2013 @ 10:23 PST | Database | Reply | Count the number of words in a phrase using Teradata SQL | Thank you Kawish for sharing a robust version, It helps me learning another way to achieve this :)
|
253 | 03 Dec 2013 @ 10:21 PST | Database | Reply | need a associated select query defined from view table in teradata? | I got your problem, I have faced this many times, SQL Assistant sometimes trim the result of show view or table due to its length.
What you can do is to use administrator, go to your databas... |
252 | 03 Dec 2013 @ 10:18 PST | Database | Reply | Error 2618 Invalid Calculation Division by Zero | Hi,
Can you please peovide the complete Where clause, Or the previous part of this AND condition?
It will help us to understand the problem.
|
251 | 03 Dec 2013 @ 10:15 PST | Database | Reply | Why I do not see all the databases in Teradata Studio | Hi,
it seems that you connection is filtering out some schemas. You can right click on your connection -> go to Properties -> go to default schema filter section and make sure that disable f... |
250 | 03 Dec 2013 @ 10:07 PST | Database | Reply | Teradata equivalent function to FROM_TZ in Oracle | Thank you Ulrich :)
|
249 | 03 Dec 2013 @ 10:12 PST | Database | Reply | Error 5505 Column data types cannot be specified with a WITH [NO] DATA clause. | Dear Kawish,
You are the man I have always idealized throughout my career, from Info-Architects to GCC, But I am unable to connect with you. Can I have your email or some other link? I am even una... |
248 | 03 Dec 2013 @ 09:21 PST | Cloud Computing | Reply | SAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud service | You can get more info at the following link
http://pk.teradata.com/News-Releases/2012/Teradata-Active-Data-Warehouses-Provide-Private-Cloud-Benefits-Today/?LangType=1056
Hope it helps you!
|
247 | 03 Dec 2013 @ 09:20 PST | Cloud Computing | Reply | SAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud service | Raja,
You can get more info at the following link
http://pk.teradata.com/News-Releases/2012/Teradata-Active-Data-Warehouses-Provide-Private-Cloud-Benefits-Today/?LangType=1056
Hope it helps you!
|
246 | 03 Dec 2013 @ 09:15 PST | Database | Reply | Teradata equivalent function to FROM_TZ in Oracle |
Ulrich,
Can we use Oracle UDF to do this? Just like we use oReplace?
just a thaught, please guide!
|
245 | 03 Dec 2013 @ 09:08 PST | Database | Reply | Teradata equivalent function to FROM_TZ in Oracle | Thanks Raja and Ulrich,
I think I will have to go for Ulrich's approach to write a UDF.
|