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.
Related Statements: DECLARE , FETCH , GET DIAGNOSTICS, INSERT , OPEN , SELECT, and UPDATE
For discussions of the DELETE statement, SPL routines, statement modification, cursors, and the SQLCODE code, see the IBM Informix Guide to SQL: Tutorial.
For information on how to access row and collections with ESQL/C host variables, see the chapter on complex data types in the IBM Informix ESQL/C Programmer's Manual.
For a discussion of the GLS aspects of the DELETE statement, see the IBM Informix GLS User's Guide.