Teradata Error Codes

By RAJ On January 23, 2012 · Leave a Comment · In Teradata

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.

If you like the post, kindly share it