Archives of the TeradataForum

Message Posted: Fri, 18 Jul 2003 @ 13:14:49 GMT

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

No, there's no "release fload" command.

I think the current release of fload simply doesn't load any data and exits with return code=0.

Bearing in mind that the "release mload" command is there to release mload locks on a table that was (potentially) already populated prior the mload job starting, releasing those locks allows you to save the table and repair it (e.g. delete, update, insert rows etc) by yourself. Given that a fastload only works against empty tables, repairing the table is either re-submitting the same job and allowing fastload to resume processing or drop the table and start again.

If you wanted to stop a fastload part way through your input file and look at the data then you can use the RECORD command to only load some records.

Dave

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