#DateForumTypeThreadPost
928 Dec 2015 @ 01:17 PSTDatabaseReplyMerge Statement Roll back data for RI Violation- BTEQThank you Dieter that makes sense.   Also  can youplease tell me how to identify perticular row of original table using ETC_RowId column from Error table.
824 Dec 2015 @ 08:39 PSTDatabaseReplyHandling the EMPTY/NULL value in the select queryIn simple terms using merge statement i dont want to roll back good records when any failure occurs. my merge statement should let all good records continue to insert  and log all error recor...
724 Dec 2015 @ 07:37 PSTDatabaseTopicMerge Statement Roll back data for RI Violation- BTEQWhen i am using below merge into statement where i am trying to insert 200 resords and encounter with Referential integrity violation for 80 records and logged them into to error table with actual ...
624 Dec 2015 @ 07:31 PSTToolsReplyBTEQ - Row Level COMMITwill sure post in Database forum too..
524 Dec 2015 @ 07:31 PSTToolsReplyBTEQ - Row Level COMMITWhen i am using below merge into statement where i am trying to insert 200 resords and encounter with Referential integrity violation for 80 records and logged them into to error table with actual ...
423 Dec 2015 @ 12:00 PSTToolsReplyBTEQ - Row Level COMMIT.SHOW VERSIONS return following versions...      BTEQ Version 14.10.00.00 for Linux running Socket TCP/IP  CLIV2      : 14.10.00.00  COPERR....
323 Dec 2015 @ 11:58 PSTToolsReplyBTEQ - Row Level COMMIT BTEQ 14.10.00.00 Wed Dec 23 10:40:00 2015        *** Logon successfully completed.  *** Teradata Database Release is 14.00.04.03  *** Terada...
222 Dec 2015 @ 08:55 PSTToolsReplyBTEQ - Row Level COMMITme either tried Merge into statement to perform inserts if no match .for me out of 250 records 100 records written to error table which are failed to  due to  Ri volation and rest 150 was...
115 Jul 2013 @ 09:45 PDTDatabaseTopicTeradatawhat is TPT