Teradata Error Codes

In Teradata every Error is shown by an Error Code and corresponding description. Sometimes while using some utilities we may have some records in Error Tables. At that time we can see ErrorCodes in the table however Error Description is missing. So it may become little difficult to understand the issue. If a user knows about these Error Codes, it is comparatively easier to debug the code. To see all the ErrorCodes available in Teradata , user can query  DBC.ErrorMsgs to see list of all the ErrorCodes available along with their description.

SELECT * FROM DBC.ErrorMsgs;

Alternatively, user can also refer to the document available on the Teradata Web Portal for Teradata Error Code PDF.

Leave a Reply

Your email address will not be published. Required fields are marked *