In a database that is not ANSI compliant, the database server does not return a warning when it finds no matching rows for the WHERE clause of an UPDATE statement. The SQLSTATE code is 00000 and the SQLCODE code is zero (0). If the UPDATE ... WHERE statement is part of a multistatement PREPARE, however, and no rows are returned, the database server issues a warning, and sets SQLSTATE to 02000 and sets SQLCODE to 100.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]