#DateForumTypeThreadPost
1630 Jan 2015 @ 10:05 PSTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementHello Steve, We are converting our data loads to use the TPT interface.  We're having a similar problem and wanted to find a fix.  Here's the setup: Moving data from Teradata sy...
1529 Jul 2013 @ 07:21 PDTDatabaseTopicDatabase MaxspoolHello,   I understand how maxspool works for users and profiles, but am uncertain if the same rules or sizing techniques apply when creating a database.  So when I am creating a databas...
1430 Jan 2013 @ 05:01 PSTConnectivityReplyTerminating ODBC Connections using other programming languages such as PythonHello,   We are experiencing the same problem as well.  Have you had any progress in resolving the issue?  Did you open an Incident?   Thanks,   Linda
1313 Mar 2012 @ 05:57 PDTDatabaseTopicAWTs and replication Hello,   I notice in Viewpoint that the GG replication loading into our Teradata Production system has persistent connections in the "Responding" status.  Do they con...
1213 Mar 2012 @ 05:53 PDTDatabaseTopicMload - how many AWTs? Hello,   We notice in Viewpoint that our Mload jobs are assigned session IDs for each thread, but only 1 of the sessions has a workload associated with it.   Does that mea...
1106 Mar 2012 @ 09:18 PSTDatabaseReplyBlocking collection and viewpoint Thanks!  Do you know what table(s) the blocking information is stored in?
1027 Feb 2012 @ 02:30 PSTDatabaseTopicBlocking collection and viewpoint Where can I find blocking information in the database?  I noticed that in Viewpoint 13.11, blocks are displayed during re-wind.  Where is the data retained that provides that informati...
913 Dec 2011 @ 11:56 PSTDatabaseTopicAfter Insert trigger Hello,   I am trying to create the following trigger, which is almost identical to a sample one that Teradata offers in their documentation.  However, I receive the error "...
830 Jun 2009 @ 09:17 PDTUDATopicmanaging deleted rows with viewsHello,Our data warehouse marks deleted records (soft deletes) and then removes them from the tables at a later time. Ideally, we would like the ability to make the delete process seamless from the...
703 Jun 2009 @ 10:12 PDTDatabaseTopicHow to revoke logon from all but a userHello,After a system expansion, we would like to revoke the logon of the users, but not the data loader ID. How is this done?Thanks for your time,Linda
626 Jan 2009 @ 10:33 PSTUDATopicWhile Loop performanceWe are converting a stored procedure from Sybase to Teradata that contains 20+ while loops and uses global temporary tables. We have found performance to vary dramatically based upon system activi...
530 Dec 2008 @ 03:41 PSTUDATopicUnicode to LatinHello, Our production tables have all been created using "character set LATIN not casespecific". However, we have a tool that has created some tables using "character set UNICODE not casespecific...
419 May 2008 @ 10:28 PDTThird Party SoftwareTopicInformatica and mload SecurityWe would like to use Teradata sso or a 3rd party authentication tool (com object) with Informatica creating mload scripts loading data into Teradata. Is this possible? Is it possible NOT to store...
328 Mar 2008 @ 09:36 PDTToolsReplyFormat Query Icon in SQL AssistantHello,We are having the same problem on an Analysts computer. We've re-installed, but still did not correct the situation. Does anyone have a resolution?Thanks
204 Dec 2007 @ 11:16 PSTThird Party SoftwareReplyHow to exec macro from MS Access?Hello,Could you expand as to how to work around? Again, we can execute a stproc (MS Access or Sybase) that has multiple statements, but only 1 select (at the end of the stproc) and this works OK a...
129 Nov 2007 @ 03:15 PSTThird Party SoftwareTopicHow to exec macro from MS Access?Hello,I am trying to "exec" a macro from MS Access as a pass-through query. However, if the macro has insert/update/delete then a select, no data will be returned with an error of "Pass-through qu...