16 | 30 Jan 2015 @ 10:05 PST | Tools | Reply | EXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statement | Hello 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... |
15 | 29 Jul 2013 @ 07:21 PDT | Database | Topic | Database Maxspool | Hello,
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... |
14 | 30 Jan 2013 @ 05:01 PST | Connectivity | Reply | Terminating ODBC Connections using other programming languages such as Python | Hello,
We are experiencing the same problem as well. Have you had any progress in resolving the issue? Did you open an Incident?
Thanks,
Linda
|
13 | 13 Mar 2012 @ 05:57 PDT | Database | Topic | AWTs 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... |
12 | 13 Mar 2012 @ 05:53 PDT | Database | Topic | Mload - 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... |
11 | 06 Mar 2012 @ 09:18 PST | Database | Reply | Blocking collection and viewpoint |
Thanks! Do you know what table(s) the blocking information is stored in?
|
10 | 27 Feb 2012 @ 02:30 PST | Database | Topic | Blocking 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... |
9 | 13 Dec 2011 @ 11:56 PST | Database | Topic | After 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 "... |
8 | 30 Jun 2009 @ 09:17 PDT | UDA | Topic | managing deleted rows with views | Hello,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... |
7 | 03 Jun 2009 @ 10:12 PDT | Database | Topic | How to revoke logon from all but a user | Hello,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 |
6 | 26 Jan 2009 @ 10:33 PST | UDA | Topic | While Loop performance | We 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... |
5 | 30 Dec 2008 @ 03:41 PST | UDA | Topic | Unicode to Latin | Hello, 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... |
4 | 19 May 2008 @ 10:28 PDT | Third Party Software | Topic | Informatica and mload Security | We 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... |
3 | 28 Mar 2008 @ 09:36 PDT | Tools | Reply | Format Query Icon in SQL Assistant | Hello,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 |
2 | 04 Dec 2007 @ 11:16 PST | Third Party Software | Reply | How 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... |
1 | 29 Nov 2007 @ 03:15 PST | Third Party Software | Topic | How 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... |