Archives of the TeradataForum

Message Posted: Fri, 18 Jul 2003 @ 21:27:25 GMT

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

There is no release fload.

No need to drop the table also.

You will have to run an empty fastload to release the table lock.

Put this in sql file, say a.sql

sessions 1;
LOGON PROD/user,pwd;
BEGIN LOADING DBname.TBLname ERRORFILES err_db.et1, err_db.et2;
END LOADING ;
LOGOFF;

and from the command prompt(hope you are on Unix) fastload < a.sql

Hope that helps.

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