Archives of the TeradataForum

Message Posted: Sat, 03 Sep 2016 @ 11:25:44 GMT

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

Sreedhar,

It is never a good idea to automate these things.

If a previous load failed, it should ideally be investigated by a human.

No load should ideally ever fail. If the load file creation was done properly, with necessary data quality checks, a load should almost never fail.

Hiding such problems is not a good idea.

If you really need to automate this, consider using a stored procedure that will do the error handling.

Then you could check Mload with the "in apply" as well as without it.

Then invoke the stored proc in your TPT instead of the release command.

Kind regards

Etienne Stieger
Data Services |Teradata Support
Group Technology Shared? Services | Standard Bank

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