Archives of the TeradataForum

Message Posted: Mon, 12 Feb 2007 @ 13:59:39 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Monday, February 12, 2007 08:57 -->

If you truly want to "circumvent" the 3604, load into staging tables that allow NULL and use SQL to validate the data before INSERT/SELECT into the target table.

If you are just trying to "locate" the error, 3604 most often occurs when the input record does not appear to have enough column values to match the definition - for example, if a text field has embedded newline characters. And SourceSeq gives you the relative record number in the input file.

	<Prev	Next>		<<First	<Prev	Next>	Last>>