Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


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;
.LOGOFF 24;
.ELSE;
.ENDIF;
.IF &SYSUVCNT1 NE 0 THEN;
.LOGOFF 25;
.ELSE;
.ENDIF;
.LOGOFF;



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020