Archives of the TeradataForum

Message Posted: Fri, 16 Aug 2002 @ 20:29:14 GMT

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

Hi Boyan:

The RELEASE is only for a MultiLoad lock. This is needed at times because the table can contain rows at the beginning of the load job.

Since FastLoad will only load to an empty table, it is not needed. Any table that is being Fastloaded stays empty until the FastLoad finishes. Until then, the rows only exist in a worktable, not the real table.

So, you need to finish your fastload, or you need to drop the table definition and your 2 errortables and pretend the Fastload never ran. Hence, it is normally better to finish your FastLoad.

Hope this helps,

Mike

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