|
|
|
Forum Member
 
Group: Forum Members
Last Login: 1/25/2007 11:21:00 AM
Posts: 25,
Visits: 1
|
|
Hello everyone,
Can we make a MLOAD script fail when the error tables are created.
Currently the mload scripts exits with a return code = 0 which means loading is successful even though it is not.It has created some error tables which indicate some data has been rejected....
Any help will be appreciated...Thanks in advance
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 4:01:17 PM
Posts: 91,
Visits: 118
|
|
Try this - sets the RC to the max rc + uv + et + reject count
.logoff &SYSUVCNT + &SYSRJCTCNT + &SYSETCNT + &SYSRC;
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 1/25/2007 11:21:00 AM
Posts: 25,
Visits: 1
|
|
Thanks Jeff...Can you please give me more details..I am new to Teradata...
Where can we set these pre-defined system variables in the mload script?
Is it possible to assign values to these variables i.e one variable which represents data for error table 1 and one variable for error table 2?
It would be great if you could provide me those details
Appreciate your help...
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 1/25/2007 11:21:00 AM
Posts: 25,
Visits: 1
|
|
Thanks jeff.,
I tried out the following and it worked
.IF &SYSETCNT1 > 0 THEN ;
.LOGOFF 12;
.ELSE;
.IF &SYSUVCNT1 > 0 THEN;
.LOGOFF 12;
.ENDIF;
.ENDIF;
Appreciate for all the help
|
|
|
|