#DateForumTypeThreadPost
1725 Feb 2010 @ 04:04 PSTDatabaseReplyTeradata PerfomanceHi,Thanks for the response. I reordered the literals but this did not make any difference to the performance of the query, even though the explain plans show the same ordering.
1622 Feb 2010 @ 10:04 PSTDatabaseReplyTeradata PerfomanceHi,The code is slower everytime I run it. I have run the before and after code on different machines and data and turns out the code is consistently slower.It doesnt make much sense seeing as the ...
1518 Feb 2010 @ 05:28 PSTDatabaseTopicTeradata PerfomanceHi guys,This looks to me like a strange one!I have a query below: UPDATE Table1 SET col1 = CASE WHEN (col2 = 'Y' AND col3 IN ('DQ','FQ','NC','NB','NA')) OR col3 IN ('RN'...
1415 Sep 2009 @ 04:28 PDTUDAReplyROW_NUMBER() - numeric overflow errorHi Jimm,Thanks so much for your help. That worked a treat!!!
1314 Sep 2009 @ 05:23 PDTUDATopicROW_NUMBER() - numeric overflow errorHi,I am trying to run the following SQL but I get a 2616: Numeric overflow occured during computation error.Can someone explain why this happens and maybe suggest a solution.Thanks,KarenSELECT (CA...
1206 Aug 2009 @ 07:50 PDTTrainingTopicTraining materials i.e books, exam questionsHi guys,I want to start my certification path on teradata. I have been looking on the web but I cannot find any good material for the exams. Can someone recommend books/exam resources that would ...
1116 Jul 2009 @ 10:03 PDTUDAReplyBehaviour of adding numeric valuesHi Dieter,That solved it.Thanks,Karen
1016 Jul 2009 @ 06:26 PDTUDATopicBehaviour of adding numeric valuesHi,I have the following statementms_key_id = CAST(((Ms_rcm_key_id * 1000000000) + ms_handler_key_id) AS NUMERIC(18)) ;where ms_rcm_key_id = 71700000 ms_handler_key_id = 15898.I expect and ...
908 Apr 2009 @ 12:32 PDTUDATopicFORMAT m/d/yy column as DD/MM/YYYYHi all,I have a column coming down from an As400 extract. the format of this date column is m/d/yy, take the following date example1st of April 2009 ---> 4/1/09 on extract.I want to format...
823 Jan 2009 @ 11:31 PSTUDATopicRuns in QueryMan, fails in BTEQHi All,I have the following code:INSERT INTO get_bcp_q_toctask SELECT C_Ref , COALESCE(CAST(a.calendar_date AS DATE FORMAT 'YYYYMMDD'), CAST('19000101' AS DATE FORMAT 'YYYYMMDD')) C...
721 Jan 2009 @ 05:29 PSTUDATopicRandomly generate idsI have the following code.What I want to do is, for each record not found in claim, i want to assign a distinct version_id to each version and a distinct ref_id to each reference.(all negative valu...
621 Jan 2009 @ 03:50 PSTUDAReplyReturn a version id as at a particular dateHiI wanted to give you feedback on you solution provided. It did not give me back the latest version of the instruction when I tested it. I expect to see one version record per instruction and th...
508 Jan 2009 @ 04:20 PSTDatabaseReplyRemove characters after '-' in a stringThat worked a treat. Thanks for your help
407 Jan 2009 @ 07:18 PSTDatabaseTopicRemove characters after '-' in a stringHi all,I have the following string '10041477/2008/021-2 '. What I want to do is remove the characters after the '-'. The field is defined as CHAR(20). There is not always 17 places before the '-...
306 Jan 2009 @ 07:49 PSTUDATopicReturn a version id as at a particular dateHi guys,I am looking for a solution to the following problem. I have two tables as outlined below. I want to join these two tables based on the reference column but only want versions effective a...
228 Nov 2008 @ 06:33 PSTUDAReplychar to timestampHi,Thanks for the quick response. Sorry, was a typo with the ). I was under the impression that you have to cast the format string as a char in queryman, not the case with BTEQ! Again, I am only ...
128 Nov 2008 @ 06:19 PSTUDATopicchar to timestampHi,I am new to Teradata but I am already finding timestamps and dates a bit of a headache. My source tableCT source_table (date_modified char(100))I want to insert this field into my destination t...