Archives of the TeradataForum
Message Posted: Thu, 05 Sep 2013 @ 12:50:47 GMT
I'm not sure exactly what you want.
If you want the error code and description (your words) then you've got them. " Failed  Duplicate unique primary key error in T2."
If you want them inserted into a table then BTEQ won't do this directly. This is typically done using a script (shell, windows PowerShell as appropriate) which reads the BTEQ log file and then inserts the data into a table.
If you want to know which row of data causes the problem then you can:
- run the insert but use the LOGGING ERRORS option (check the SQL manual for syntax details)
- run a SELECT looking for key values that occur in multiple rows
- INSERT/SELECT into a MULTISET table with no Unique index and do the same as the previous suggestion
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|