#DateForumTypeThreadPost
6212 Sep 2007 @ 05:37 PDTUDATopicLinux Program calling NetVault for Teradata BackupApologies if this is in the wrong forum. Please diirect me to the correct one if this is so.We have a NetVault event called 'Prod_Root_Trigger' that is triggered as below.We seem to get intermittan...
6131 Aug 2007 @ 12:21 PDTUDAReplyData SkewI've checked the stats.select hashamp(hashbucket(hashrow(job_id))) ,count(*)from log_tablegroup by 1;11 140 327 413 13122 this is the problem1 305 329 2364 62 1012 123 88310 88 306 28I know exac...
6031 Aug 2007 @ 10:03 PDTUDAReplyData SkewI think the fix is to backup the current table, redefine it with a more suitable primary index and copy back in the data to the new table.I think this will redistribute the data across the amps aga...
5931 Aug 2007 @ 09:38 PDTUDATopicData SkewI noticed that last night during our data warehouse run that some log entries were not occurring towards the end of the run.The log generated from our controlling linux problem suggested that the l...
5824 Aug 2007 @ 04:24 PDTUDAReplyTable Fields DataThanks again,Doing a pattern search on a Stored Procedure definition is exactly what I want to do. I have not been able to do it. I thought the RequestText or CommentString columns from DBC.Tables ...
5723 Aug 2007 @ 11:37 PDTUDAReplyTable Fields DataThanks that's great.What about if i wanted to see every stored procedure that referenced '%product_id%'
5623 Aug 2007 @ 09:26 PDTUDATopicTable Fields DataApologies if this is in the wrong forum or has been asked somewhere else before.If I was asked "Can you please check what tables contain the following field %product_id%?"Is there a utility to do t...
5526 Jul 2007 @ 09:03 PDTUDAReplyFast/Multi Load & Control CharactersWe are researching the idea of cleaning at the source.The problem is at the moment that the main 'block looking' cntrl characters(they seem to be carriage returns and line feeds) we are receiving m...
5424 Jul 2007 @ 11:59 PDTUDAReplydate formatSELECT cast(cast((cast(date_id as date format 'yyyymmdd') + v_Days) as date format 'yyyymmdd') as char(8)) FROM GEt_lu_snapshot;I got what I wanted using this.There seems to be a little quirk bet...
5324 Jul 2007 @ 06:48 PDTUDATopicdate formatselect cast('20070620' as date format 'yyyymmdd') + -120;gives me 20/02/2007but i need the following format:20070220How can I do this?
5210 Jul 2007 @ 11:43 PDTUDAReplyCase Statement 2No but this did..SELECT top 5 (CASE WHEN r9.rated_driver_id Is Not Null AND t9.rated_P_driver_code Is Null AND 'H' || trim(t7.corrected_product_type) ...
5110 Jul 2007 @ 04:08 PDTUDAReplyCase Statement 2Thanks barry but it does need to reference the column. (po_risk_detail_cursor.tr_single_driver)I'm not trying to use any variables.the logic simply is If r9.rated_driver_id Is Not Null AND t9.rated...
5009 Jul 2007 @ 10:03 PDTUDATopicCase Statement 2I've walked myself into a wall tonight. The below works but when I attempt to add in the 2 commented out lines i get syntax error. the desired result is to ensure that when the 1st(biggest) case st...
4909 Jul 2007 @ 05:42 PDTUDAReplyCASE Statementthanks all
4806 Jul 2007 @ 08:06 PDTUDAReplyCASE StatementAlso it looks like it doesn't like the coalesce statement within caseIs this possible?
4706 Jul 2007 @ 07:15 PDTUDATopicCASE StatementI basically want to add a case statement to say if rated_driver_id Is Not Null AND rated_P_driver_id Is Null AND 'H' || trim(t7.corrected_product_type) in ('HQMV', 'HQMF', 'HQMP', 'HQMB') then COAL...
4604 Jul 2007 @ 09:00 PDTUDAReplyFast/Multi Load & Control CharactersThanks Joe.One of the better ideas I've been presented with is as below. Any thoughts are very much appreciated?The problem relates to what is a control character and what is not. The cent charact...
4504 Jul 2007 @ 08:55 PDTTrainingReplyNumber Data Typedeleted a mis directed thread. can't see a delete option. apologies.
4402 Jul 2007 @ 12:16 PDTUDAReplyFast/Multi Load & Control Charactersexcuse my ignorance.but what do you mean by 'fixed width' and 'named FIFO'?Can you use examples?Marc
4302 Jul 2007 @ 12:14 PDTUDATopicBegin Transaction / End TransactionCan anyone answer this one....I have a procedure that is running inside a BT/ET transaction.However it failed for no apparent reason yesterday. When i remove the BT ET at the beginning and end it r...
4202 Jul 2007 @ 06:00 PDTUDATopicFast/Multi Load & Control CharactersOur source data is loaded into our warehouse staging area via combination of Fast & Multi Load utilities.From time to time some CNTRL characters can slip into the source systems data.For example an...
4129 Jun 2007 @ 10:07 PDTUDAReplyproduct Jointhanks guys i will look at ball approaches.
4028 Jun 2007 @ 09:21 PDTUDATopicproduct JoinPlease help me eliminate the product join on this query as it's driving me mad.I'ld prefer to not change the structure of the query at this stage though.When i remove the lines from the OR statemt ...
3901 Jun 2007 @ 04:53 PDTConnectivityReplyTdConnection is not openThanks for the reply.I did run in TTU Rel 8 but then unistalled and reinstalled the correct versions of Shared ICU, GSS and CLIv2.In the meantime i have incorporated the System.Exception and it was...
3830 May 2007 @ 10:08 PDTDatabaseTopicDirty ReadsWhen wishing to do a dirty read in SQLServer I would do this... Sel * From Tbl_1(nolock), Tbl_2(nolock) Where Col1 = Col2....The equivalent is 'Locking Table For Access' in Teradata but what if I ...

Pages