All forum activity

#DateUserForumTypeThreadPost
29409 Feb 2006 @ 04:23 PSTronitDatabaseTopicexplain planHi,Where can i find a didtailed explain on the explain plan.How tera decides when to use the index and when not? ThanksRonir
29309 Feb 2006 @ 04:15 PSTronitDatabaseReplyinfluance record length on the performanceHi,Thanks. I've another question Is there a difference on the way it manage the spool?
29208 Feb 2006 @ 03:35 PSTJim ChapmanUDAReplyDeadlock and isolation levelsIf your application queries a table and then updates it within the same transaction, it is vulnerable to a classic deadlock scenario. The query will acquire a read lock and then attempt to upgrade...
29108 Feb 2006 @ 01:36 PSTshaik.feroz@aaa-calif.comDatabaseReplyHow to Specifying date range (Date + Hour) in the queryI am not sure if i understood your question correct.But if you want the timestamps to be date instead you can cast them to date.select sum(TotalCpuTime) from DBC.QryLog WHERE cast(LogonDateTime as ...
29008 Feb 2006 @ 01:28 PSTNataliaDatabaseReplyMonth differenceThanks. :-)
28908 Feb 2006 @ 01:24 PSTshaik.feroz@aaa-calif.comDatabaseReplyMonth differencedate '2006-01-01' - date '2006-03-01' is not 2 it is -2try this select date '2006-03-01' - date '2006-01-01' month as ActualMonthsthe result will be 2but the problem with this operation is select...
28808 Feb 2006 @ 12:27 PSTDaveWellmanDatabaseReplyWarehouse 8.0 Demo ?I spoke to Teradata about this a couple of weeks ago and was told that "we have no plans to produce one".Seems a shame, but there you are.Dave
28708 Feb 2006 @ 11:50 PSTKrishan.RDatabaseTopicHow to Specifying date range (Date + Hour) in the queryI am trying find out the CPU time utilization for the previous day by some intensive SQL jobs. The input is from the DBQL table. I would like to specify the time range in the previous day. How I do...
28608 Feb 2006 @ 09:54 PSTNataliaDatabaseTopicMonth differenceHi!Someone knows how to calculate month difference between two dates?For example:=> date '2006-01-01' - date '2006-03-01' = 2 monthsI know that I could calculate by division, but it could be not ex...
28508 Feb 2006 @ 09:44 PSTTD_ArchDatabaseReplycan insert the derived table in Between clause?The following query will work:select * from date_exmp wherereq_dte between date-10 and date;
28408 Feb 2006 @ 09:41 PSTTD_ArchDatabaseReplyHow to get Teradata Version ?select * from dbc.dbcinfo;This will work only if you have access rights to query the dbc. Else, when you start bteq, your release will be displayed ( this happens on V2R6 ).
28308 Feb 2006 @ 09:34 PSTrprinsenUDAReplyDeadlock and isolation levelsJason, wonderful, thank you.
28208 Feb 2006 @ 09:17 PSTjasonfUDAReplyDeadlock and isolation levelsYes, go to http://www.info.ncr.com/Teradata/eTeradata-BrowseBy.cfmClick on "Teradata Database", then under Titles, click "SQL Reference".Download the manual titled "SQL Reference: Statement and Tra...
28108 Feb 2006 @ 09:09 PSTrprinsenUDAReplyDeadlock and isolation levelsJason, thank you very much. I just support our ETL product and need to understand the locking mechanism of Teradata. Unfortunately I do not have manuals (yet). Are there specific ones I need to get...
28008 Feb 2006 @ 09:00 PSTjasonfUDAReplyDeadlock and isolation levelsOne option is to modify all your Select statements to include a "lock for access" qualifier.An easier method would be to create a separate database containing just views that reference the base tab...
27908 Feb 2006 @ 07:13 PSTrprinsenUDATopicDeadlock and isolation levelsNot being familiar with teradata, I have the following issue.An ETL system requires that tables can be read and written to at the same time by the same user, but different connections. Deadlocks oc...
27808 Feb 2006 @ 04:04 PSTManoj_Kumar_ParmarTrainingReplyBTEQ sample scriptsHi Dennis, I am unable to find the sample scripts, at the specified location, and I already sent a mail to you, please tell me where I can get the sample scriptswaiting for response
27708 Feb 2006 @ 02:44 PSTakhil.bansal@gmail.comDatabaseTopicHow to get Teradata Version ?Hi,How can i know which version of teradata is installed on my system ?Regards
27608 Feb 2006 @ 01:58 PSTManoj_Kumar_ParmarDatabaseTopiccan insert the derived table in Between clause?Hi All, I needed to get the dates for report at run time, the dates should be in some range, hence the "between" clause can be used. but I am unable to give the select statement in the "between" cl...
27507 Feb 2006 @ 07:45 PSTayesToolsReplywhat is wrong in this mload upsert?opps!My mistake, I was using PI in the update satement.I corrected and it is working fine.
27407 Feb 2006 @ 03:19 PSTTeraTintinTrainingTopicTeradata Certification Books for SaleI have two Tera Toms (Coffing) books to sell.These are lightly used but are in good condition.No marking, writing, or highlighting.Introduction to Teradata for (NRC -Exam 11)Teradata SQL ...
27307 Feb 2006 @ 03:07 PSTayesToolsTopicwhat is wrong in this mload upsert?Hi ,I am getting the following error in the below mentioned mload upsert."UTY0805 RDBMS failure, 3538: A MultiLoad UPDATE Statement is Invalid" I could not find what is wrong in the update statemen...
27207 Feb 2006 @ 12:25 PSTshaik.feroz@aaa-calif.comDatabaseReplyinfluance record length on the performanceYes there is a difference because the data for a long record might be running into multiple blocks, where as the data for a small record might be in just one block. This way when we you do a select...
27107 Feb 2006 @ 06:38 PSTakhil.bansal@gmail.comDatabaseTopicProblem executing recursive query from Sql AssistantHiWhen i execute the below mentionet sql from BTEQ it works fine however when it is executed from Sql Assistant it gives the error "3706: Syntax error: Expected something between the begenning of t...
27007 Feb 2006 @ 02:52 PSTronitDatabaseTopicinfluance record length on the performanceHi,I'm new in teradata. I was told that there is a difference in performance between: doing a select of a column from a long record and doing a select of a column from a short record.is it so?thank...

Pages