CODEWITHSUNDEEP
db2
zinking
zinking

Reputation: 5695

db2 ? lookup error db2 error code

I don’t know which is the shortest way to look at the error descriptions like “ERRORCODE=-4463, SQLSTATE=42601” Generally I google such kind of error descriptions and I can get the result somewhat anyways. But this turns out to be very inefficient, sometimes it is just difficult to get description regarding the error code and sql state. I know the db2 built in command like : db2 ? SQL0443N will provide information about specific SQLCODE But when encountered error description like that above , how do I turn that into a SQLCODE, so that I can lookup it quickly using db2 ?

Upvotes: 2

Views: 15741

Answers (2)

Prasad Paravatha
Prasad Paravatha

Reputation: 618

Here is the link with different DB2 error codes https://urssanj00.wordpress.com/2008/03/04/db2-sql-error-code-and-description/

This saved me tons of hours!

Upvotes: 0

zinking
zinking

Reputation: 5695

what @Clockwork-Muse commented is definitely correct.

and I am now referring to these documents for the SQL codes and states. hmm neat

SQL ERROR CODE LOOKUP

SQL STATE CODE LOOKUP

Upvotes: 5

Related Questions