Error codes table convention

Class value	Meaning
01	Indicates a warning and includes a return code of SQL_SUCCESS_WITH_INFO. Note 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. Note 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.