Archives of the TeradataForum
Message Posted: Thu, 10 Nov 2005 @ 12:41:46 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|