#DateForumTypeThreadPost
624 Jun 2013 @ 07:00 PDTDatabaseTopicSQL MERGE Detecting Duplicate RowsWe are using the SQL MERGE statement as a method to perform straight inserts.  When running in Teradata transaction mode, is there a way to detect and log records that do not make it to t...
528 Feb 2013 @ 01:17 PSTDatabaseTopicFastLoad And Query AccessI am using the FastLoad utility to remove and replace data in a table. If the DELETE command is in and part of the FastLoad script, is there any potential that another query could read the table an...
404 Feb 2013 @ 08:41 PSTDatabaseTopicPerformance of MERGE versus SQL INSERTI need to perfom the simple task of adding new data to a large existing table.  My source data is on Teradata and is in a table that looks exactly like my target table (field names, datatype, ...
305 Nov 2009 @ 04:31 PSTToolsTopicTPT And Mainframe Chanel Attached SystemsWe have our production Teradata box connected to the production mainframe via a TDP channel. Our test Teradata box is connected to the test main frame via a different TDP channel.If I initiate a TP...
205 Nov 2009 @ 04:19 PSTToolsTopicTPT Script Multiple Table QuestionLets say I have 10 tables in database ABC. I need to move the data in these 10 tables from our production box to our test box. The tables in production are on separate Teradata machine than the one...
104 Nov 2009 @ 04:25 PSTToolsTopicTeradata TPT ScriptI am attempting to write a TPT script to move data from one table to another. The tables are on two different Teradata systems (one is production the other is test). My source and target table are ...