db2 ? lookup error db2 error code

db2

Solution

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

Problem

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 ?

Original source