Archives of the TeradataForum

Message Posted: Thu, 10 Nov 2005 @ 12:41:46 GMT

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

Hi Friends,

I need to implement error handling in BTEQ scripts which will be executed from UNIX. I have a case where I execute an ins-sel "insert into tbl1 sel * from tbl2" in one of the scripts. Even if one of the rows which are supposed to be inserted by this has invalid data, the task fails without inserting any of the rows.

Is there any way by which I could get the details of the rows which are rejected due to which the whole operation fails ????

Please help me out in this.

Regards,

Srikanth S.M.

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