Error codes table convention

Class value	Meaning
01	Indicates a warning and includes a return code of SQL_SUCCESS_WITH_INFO. Error class 01 returns both warnings and errors.
01, 07, 08, 21, 22, 23, 24, 25, 28, 34, 3C, 3D, 3F, 40, 42, 44, HY	Indicates an error that includes a return value of SQL_ERROR. Error class 01 returns both warnings and errors.
IM	Indicates warning and errors that are derived from ODBC.

Note Typically, when a function successfully executes, it returns a value of SQL_SUCCESS; in some cases, however, the function may also return the SQLSTATE 00000, which also indicates successful execution.