| 319 | 16 Feb 2006 @ 06:21 PST | TDUser-781 | UDA | Reply | confidence showned in explain plan | Hi Dixondixon,the difference between these types of confidences is in the way the optimizer succeeds to estimate the dimension and the number of rows for each step of the query.No and Low confidenc... |
| 318 | 16 Feb 2006 @ 05:11 PST | dixon | UDA | Topic | confidence showned in explain plan | Hi i want to know that, what exactly the difference b/w NO, Low, High and Index Join Confidence showned in the explain plan. And how exactly we convert No Confidence to High confidence.Any Suggesti... |
| 317 | 16 Feb 2006 @ 12:52 PST | gmarul | Database | Topic | Need help on executing the BTEQ commands through PERL script | Hican anyone get me the way in which the BTEQ script/commands to be executed through the PERL script.My requirement is,In a file I'm having a set of SQL queries for TERADATA. I need to run it in TD... |
| 316 | 15 Feb 2006 @ 10:01 PST | Ranga-746 | Database | Reply | ARCHIVE Database | Hi Is there a way, where i can archive, using arcmain and put the file on a different serveras the client can not hold large fileThanksRanga |
| 315 | 15 Feb 2006 @ 09:00 PST | KM | Tools | Topic | Account ID | Hi AllI am pretty confused about the AccID which is required in all Logon screen . What’s that for , and how would I get it ? While trying to get onto PM (to find out how many AMP’s I have o... |
| 314 | 15 Feb 2006 @ 08:16 PST | Barry-1604 | Tools | Reply | Date Format In Teradata SQL Assistant | BTEQ adheres to any formatting that you put in your SQL, while ODBC passes back data in the native data type. So, in order to see the result of any formatting that you do when going through ODBC, ... |
| 313 | 15 Feb 2006 @ 05:42 PST | Sarah Qureshi | Training | Topic | Preparation for the Teradata SQL exam | Hi,I want to appear for the Teradata SQL certification. Can anyone please send me any sort of documantation that might be helpful in preparing for it?Thanks, |
| 312 | 14 Feb 2006 @ 03:25 PST | Terabeth | Jobs | Topic | Teradata - Senior Data Warehouse Engineer | Senior Data Warehouse Engineer - BHR# 130-06The Information Technology Department, at Safeway, Inc. located in Pleasanton, CA has an opening for a Senior Data Warehouse Engineer.Qualifications: T... |
| 311 | 14 Feb 2006 @ 09:17 PST | santoshkumar.bhugatha | Tools | Topic | Very Urgent | Iam Selecting Date format of 'yyyy-mm-dd' and trying to insert that in another table using join conditions. It is giving INVALID DATE and unable to insert that. Query have only join and the forma... |
| 310 | 14 Feb 2006 @ 06:55 PST | KM | Tools | Topic | Date Format In Teradata SQL Assistant | Hi the select date1(format 'yy/mm/dd') from testuser.test3; always yeilding the output 2006-01-01 when it should display '06/01/01'.I have tried with all sorts of combination , but result... |
| 309 | 14 Feb 2006 @ 01:09 PST | corpus | Jobs | Topic | Req: Teradata DBA | Our customer in Dallas is looking for a Teradata DBA consultant.Please send the resumes with rate contact number and availability.Rate is open.Location: Dallas, TXSam PrakashCorpus, Inc.972-746-464... |
| 308 | 13 Feb 2006 @ 10:08 PST | shaik.feroz@aaa-calif.com | Database | Topic | Import from MS XLS (EXCEL) file to teradata table. | I am trying to import data into a Teradata table from an excel file is this possible?I can save the excel file as tab delimited text file and then import it from queryman (sql assistant)that works.... |
| 307 | 13 Feb 2006 @ 09:52 PST | TDUser-781 | Tools | Topic | Help Index | Hi all,I was asked by a customer what SQL could replace the "help index" statement.If I simply query the indices view (or look at winddi.def file), I can extract the columns of the indexes, one col... |
| 306 | 10 Feb 2006 @ 05:11 PST | candyman | Connectivity | Reply | Teradata ODBC Trouble in MS/Access | I had this too...Please NOTE special ODBC settings:Go to ODBC settings / Configure / Options / advanced and look at the bottom two check boxes. They need to be checked. |
| 305 | 10 Feb 2006 @ 02:23 PST | Jim Chapman | Database | Reply | Tools to compare two teradata's DB and find the differences | Do you want to compare the contents of tables, or are you just looking for schema differences? |
| 304 | 10 Feb 2006 @ 12:18 PST | kchoksi-521 | Training | Topic | Table function on V2R6 | Has anyone used create function(table function form) of V2R6 ?This create a table function that can be invoked in FROM clause. |
| 303 | 10 Feb 2006 @ 07:40 PST | paloma.palacios@accenture.com | Database | Topic | Tools to compare two teradata's DB and find the differences | We would like compare two databases in Teradata and find the diferences. What tool could we used? |
| 302 | 10 Feb 2006 @ 05:04 PST | Sathish | Database | Reply | Month difference | select (extract (year from '2006-03-22' )-extract(year from '2005-01-01'))*12 + extract (month from '2006-03-22') - extract (month from '2005-01-01')14 monthsselect (extract (year from '2006-0... |
| 301 | 09 Feb 2006 @ 05:46 PST | shaik.feroz@aaa-calif.com | Database | Reply | Update using the result of a SELECT | I am not sure about the table names and the field name that you have but i guess this is how you have to write this queryupdate cpu_stat_matrixfrom (select sum(TotalCpuTime) from DBC.QryLog WHERE C... |
| 300 | 09 Feb 2006 @ 04:14 PST | Krishan.R | Database | Topic | Update using the result of a SELECT | Can some one help me to know why this update statement fails. Is it possible to useupdate using the select statement like this. Your help would be highly appreciated.###############update CPU_STAT... |
| 299 | 09 Feb 2006 @ 03:39 PST | Hashly | Analytics | Topic | Formating TIME to load using multi load | HiI wanto load a time field by using multiload. Data look like 16000000. what kind of format I use for this. FORMAT 'HHMISSSS' is not working.Thanks, |
| 298 | 09 Feb 2006 @ 11:28 PST | shaik.feroz@aaa-calif.com | Database | Reply | explain plan | This needs a long discussion, but anyways if you run the explain check for words like"By way of primary index" (rows are read using primary index column(s))"By way of index number" (rows are read u... |
| 297 | 09 Feb 2006 @ 11:20 PST | shaik.feroz@aaa-calif.com | Database | Reply | influance record length on the performance | Spool is nothing but blocks of space that can be used. it does not matter if it is a big record or a small recrod as long as the data can fit in the available spool it should work, once it exceeds ... |
| 296 | 09 Feb 2006 @ 11:13 PST | shaik.feroz@aaa-calif.com | Database | Reply | can insert the derived table in Between clause? | Manoj,I am not sure why it does not allow an select in the between clause, but it does not allow a select. The option that you had "where date_val >= (select .....) and date_val |
| 295 | 09 Feb 2006 @ 05:13 PST | Manoj_Kumar_Parmar | Database | Reply | can insert the derived table in Between clause? | Hi TD_ARch, Thanks for your reply, but my Actual requirement is that I wanted to put select statement in between clause, whether it is possible, please let me know, if not their is any specific rea... |
