All Forums Teradata Applications
jujeedeeda 1 post Joined 03/14
18 Mar 2014
Error Code: 2796 MLoad MARK MISSING DELETE

Hi all,
I have problem when mload is processing. I found error in error tables error code 2796; however, data are still loaded to taget table but it is quite slow because of this error.
Could you please suggest me what is the cause of this error?
Thank you

Fred 1096 posts Joined 08/04
24 Mar 2014

As the message says, you issued a DELETE for a row that was missing (no row matched the WHERE condition). By default, this is considered an error and is "marked" or logged to the error table. If you don't care, you can specify IGNORE MISSING DELETE ROWS in the DML LABEL.

You must sign in to leave a comment.