All Forums UDA
apes0523 4 posts Joined 03/07
14 Mar 2007
Application Error Table code 2797

My MLOAD seems to have run fine meaning I got a return code of 0 but there is no data in my target table. The only data I can find is in my Application Error Table (UV). It has ? in all of my table columns and all rows have an error code of 2797. I cannot seem to find anywhere what that error code means. I am new to Teradata and everything mainframe coding and need help but can't seem to find it. Please help me before I go bald from pulling my hair out :o\Thanks!

Barry-1604 176 posts Joined 07/05
14 Mar 2007

2797 - (from the manual) Explanation: An MLoad apply error table row withthis code marks a missing-update event where the rowspecified for update is not found in the target table.********This means that you have coded an UPDATE statement in your Multiload and have specified that you want update rows that aren't found to go to the error table.If you don't want that to happen, specify "IGNORE MISSING UPDATE ROWS" in your Mload.By the way, the manuals can be found at:www.info.ncr.comNavigate to the release that you are on. You'll probably want to download the Multiload manual and the error messages at a minimum.

RGlass 35 posts Joined 09/04
15 Mar 2007

This is handy for a quick check on errors:select * from dbc.errormsgswhere errorcode = 2797ErrorCode ErrorText2797 MLoad MARK MISSING UPDATEof course the manuals have much more detail.Bob

apes0523 4 posts Joined 03/07
15 Mar 2007

Thank you so much. I finally found the message manual on the web. That solved so many of my issues. Oh and the Multiload manual did wonders explaining things so thanks to everyone for a quick reply to help me out!!-April

You must sign in to leave a comment.