Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 14:03:43 GMT

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

The following code will work right in the Multiload utility step. It goes after the END MLOAD statement and before the LOGOFF statement. You get the error in the step that caused the problem and not in a following step like using the BTEQ solution below. You can check the ET and UV tables for errors or check for INSERTS, DELETES, UPDATES (whatever you desire). It will work on all 5 tables you Multiload by checking &SYSETCNT2, &SYSETCNT3, &SYSUVCNT2, etc. You can code whatever return code you want. If there are errors in both, you will only get the return code for the first one, but you can check the second when you are checking out the bad return code from the first one.

.IF &SYSETCNT1 NE 0 THEN;
.LOGOFF 24;
.ELSE;
.ENDIF;
.IF &SYSUVCNT1 NE 0 THEN;
.LOGOFF 25;
.ELSE;
.ENDIF;
.LOGOFF;

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