SQLSTATE Values in a Database That Is Not ANSI-Compliant

In a database that is not ANSI compliant, the database server does not return a warning when it finds no rows satisfying the WHERE clause of a DELETE statement. In this case, the SQLSTATE code is 00000 and the SQLCODE code is zero (0). If the DELETE . . . WHERE is part of a multistatement prepared object, however, and no rows are returned, the database server does issue a warning. It sets SQLSTATE to 02000 and sets the SQLCODE value to 100.

For information on the ANSI/ISO-compliance status of values returned to the SQLSTATE variable, see the section SQLSTATE Support for the ANSI/ISO Standard for SQL.