#DateForumTypeThreadPost
1023 Feb 2010 @ 12:41 PSTUDAReplyTrying to Identify Logons that are not assigned to a the person whom it belongs to.I'm trying to find users that are not logging on with their own userid but a generic id Like a ETL user. I want a report to publish each day of anyone who meets this criteria. I could deploy IP fil...
919 Feb 2010 @ 04:42 PSTUDATopicTrying to Identify Logons that are not assigned to a the person whom it belongs to.Trying to Identify Logons that are not assigned to a the person whom it belongs to. I want to generate a report to accomplish this. Any help would be great.
817 Dec 2009 @ 08:07 PSTJobsReplyTeradata DBA Wanted in UKDBA position. Looking for a prem position. I live in the US and I'm willing to move. Please tell me more
713 Apr 2009 @ 08:27 PDTAnalyticsReplydrop Statistics before recollectingNo, you do not.
608 Jan 2009 @ 08:24 PSTUDATopicLooking for dynamic SQL for cloning stats from a table.Does anyone have a sql that will clone stats for a table?
530 Nov 2008 @ 12:13 PSTTrainingReplyTERADATA CERTIFICATIONTry here:www.coffingdw.com/basicsbook.asp This should get you started.
430 Nov 2008 @ 12:08 PSTUDATopicWhat is the best way to copy data to the mainframe?I'm trying to copy data to the mainframe for user testing. Can anyone just give me a suggestion of what is the best way to accomplish this.
324 Sep 2008 @ 12:22 PDTAnalyticsTopicHow to search for all % in a columnSELECT v_high, v_low, INDEX(first_hit_referrer,'%') AS location, SUBSTRING(first_hit_referrer FROM INDEX(first_hit_referrer,'%') FOR 3) AS val, first_hit_referrerFROM tbl1WHERE FIRST_HIT_REFERRER L...
217 Jul 2008 @ 05:21 PDTAnalyticsReply2651: Operation Error computing expression involvingAlso I can run this query sometimes and it gives a the a result set. truned around and rand it again and you get the error (2651).
117 Jul 2008 @ 05:12 PDTAnalyticsTopic2651: Operation Error computing expression involvingHas anyone encountered a error like this? 2651: Operation Error computing expression involving cth_afflt_comsn_or_id.comsn_end_dttm. Output directed to Answerset windowPlease help....bohica