All forum activity

#DateUserForumTypeThreadPost
31916 Feb 2006 @ 06:21 PSTTDUser-781UDAReplyconfidence showned in explain planHi 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...
31816 Feb 2006 @ 05:11 PSTdixonUDATopicconfidence showned in explain planHi 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...
31716 Feb 2006 @ 12:52 PSTgmarulDatabaseTopicNeed help on executing the BTEQ commands through PERL scriptHican 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...
31615 Feb 2006 @ 10:01 PSTRanga-746DatabaseReplyARCHIVE DatabaseHi 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
31515 Feb 2006 @ 09:00 PSTKMToolsTopicAccount IDHi 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...
31415 Feb 2006 @ 08:16 PSTBarry-1604ToolsReplyDate Format In Teradata SQL AssistantBTEQ 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, ...
31315 Feb 2006 @ 05:42 PSTSarah QureshiTrainingTopicPreparation for the Teradata SQL examHi,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,
31214 Feb 2006 @ 03:25 PSTTerabethJobsTopicTeradata - Senior Data Warehouse EngineerSenior 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...
31114 Feb 2006 @ 09:17 PSTsantoshkumar.bhugathaToolsTopicVery UrgentIam 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...
31014 Feb 2006 @ 06:55 PSTKMToolsTopicDate Format In Teradata SQL AssistantHi 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...
30914 Feb 2006 @ 01:09 PSTcorpusJobsTopicReq: Teradata DBAOur 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...
30813 Feb 2006 @ 10:08 PSTshaik.feroz@aaa-calif.comDatabaseTopicImport 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....
30713 Feb 2006 @ 09:52 PSTTDUser-781ToolsTopicHelp IndexHi 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...
30610 Feb 2006 @ 05:11 PSTcandymanConnectivityReplyTeradata ODBC Trouble in MS/AccessI 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.
30510 Feb 2006 @ 02:23 PSTJim ChapmanDatabaseReplyTools to compare two teradata's DB and find the differencesDo you want to compare the contents of tables, or are you just looking for schema differences?
30410 Feb 2006 @ 12:18 PSTkchoksi-521TrainingTopicTable function on V2R6Has anyone used create function(table function form) of V2R6 ?This create a table function that can be invoked in FROM clause.
30310 Feb 2006 @ 07:40 PSTpaloma.palacios@accenture.comDatabaseTopicTools to compare two teradata's DB and find the differencesWe would like compare two databases in Teradata and find the diferences. What tool could we used?
30210 Feb 2006 @ 05:04 PSTSathishDatabaseReplyMonth differenceselect (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...
30109 Feb 2006 @ 05:46 PSTshaik.feroz@aaa-calif.comDatabaseReplyUpdate using the result of a SELECTI 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...
30009 Feb 2006 @ 04:14 PSTKrishan.RDatabaseTopicUpdate using the result of a SELECTCan 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...
29909 Feb 2006 @ 03:39 PSTHashlyAnalyticsTopicFormating TIME to load using multi loadHiI 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,
29809 Feb 2006 @ 11:28 PSTshaik.feroz@aaa-calif.comDatabaseReplyexplain planThis 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...
29709 Feb 2006 @ 11:20 PSTshaik.feroz@aaa-calif.comDatabaseReplyinfluance record length on the performanceSpool 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 ...
29609 Feb 2006 @ 11:13 PSTshaik.feroz@aaa-calif.comDatabaseReplycan 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
29509 Feb 2006 @ 05:13 PSTManoj_Kumar_ParmarDatabaseReplycan 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...

Pages