#DateForumTypeThreadPost
1514 May 2015 @ 09:53 PDTDatabaseReplyAWT Count more than 500? !!Check here:   http://developer.teradata.com/blog/carrie/2009/04/simplifying-amp-worker-task-monitoring-and-getting-it-right and here https://developer.teradata.com/blog/carrie/2013/01/usin...
1409 Jan 2015 @ 02:41 PSTDatabaseReplyChange accout string of sessions outside of your ownPerfect!  This is exactly what I was looking for, and thought I had looked in the docs for. :)   thanks again!!
1309 Jan 2015 @ 08:03 PSTDatabaseTopicChange accout string of sessions outside of your ownGood Morning,   Our currectl WLM rules classify certain users based on account strings.  We give users an account string of say "hi_pri" which allows them to run at higher pri...
1205 Jan 2015 @ 02:46 PSTDatabaseReplyExecute immediate - exception handlingCan you post how you resolved it?
1102 Dec 2014 @ 12:48 PSTDatabaseTopicStored Procedure switching userI have a stored procedure I call to create a role, profile, and a couple users.  The SP finishes successfully, but after finishing I am no longer the user I logged on as, but rather the user t...
1020 Nov 2014 @ 07:45 PSTTeradata StudioReplyMoving cursor around in large SQL Editor files is sluggishI had the same issue. In teradatastudio.ini (or teradataatudioexpress.ini) you can edit the min and max memory allocation for your Java heap. I just upped the max memory and works like a charm now.
907 Nov 2014 @ 06:34 PSTToolsReplyTPT 15.00 Teradata <> HDP Sanbox data movementHey Steve (Feinholz),   I told you at Partners I'd mention you by name in my next post.  Well this is it :)  Any guidance you have would be great, though this is likely more su...
806 Nov 2014 @ 07:50 PSTToolsTopicTPT 15.00 Teradata <> HDP Sanbox data movementGood Evening,   I'm trying to prove out using TPT 15.00 to move data back and forth between Teradata and Hadoop.  I'm hoping to get the benefit of using fastexport rather than a...
725 Jul 2014 @ 04:33 PDTConnectivityReplyConnecting to Teradata using PythonSo I spent a good few hours trying to figure this one out a couple weeks back...  What type of driver are you trying to use and which python package are you using?  I found pyodbc to be t...
620 Jul 2014 @ 04:06 PDTDatabaseTopicRevoke access based on user and appHello all,   im sure there are many peie who have been tasked with curbing the abilities of "shadow IT" to build their own automated processes. I have been given the same task. I w...
528 Mar 2014 @ 04:59 PDTTeradata ApplicationsReplyNexus Query ChameleonGet 'em.
423 Jan 2013 @ 03:58 PSTToolsTopicCopying Statistics with ARC from Teradata < v14 to Teradata v14We are switching to a Dual Load to remove our DCM application from the box our EDW runs on.  I was tasked with moving all DCM specific databases off of the EDW (v13.10) box and onto a shiny ne...
309 Jan 2013 @ 08:19 PSTAnalyticsReplyRow counts for every table in a given databaseI find this solution to be slightly more elegant.  You don't need to worry about truncation of table / db names.  It also allows you to get info for more than one database at time , g...
220 Jun 2012 @ 01:48 PDTViewpointTopicViewpoint Access Alert   I was wondering if it was possible to generate an alert for a user logging into viewpoint who should not have access to a certain ID.  For example, to find unautohorized access t...
127 Apr 2011 @ 05:34 PDTDatabaseReplyCollect Stats - How Performance gets improved?Hey Sanjeev. You shouldn't alias your table as the same table name. This will force a product join, which will give you that high estimated completion time. Try: update SYS_PUR from ( sel...