Archives of the TeradataForum
Message Posted: Thu, 05 Dec 2002 @ 14:03:43 GMT
| Subj: || || Re: Multiload Completion Notification |
| From: || || Larry Girardin |
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;
.IF &SYSUVCNT1 NE 0 THEN;