Re: ESQL/C question about sqlca.sqlcode after "EXEC SQL UPDATE..

Posted in 1994

Jonathan Leffler — 1 Sep 1994 21:03:07 -0400 — source: Informix-list mailing list archive (1991-1998)

>From: BULLOCK@lexmark.com >Subject: ESQL/C question about sqlca.sqlcode after "EXEC SQL UPDATE.. >Date: Thu, 1 Sep 1994 21:24:56 GMT >X-Informix-List-Id: <news.8458> >I'm using ESQL / C with Informix Online V5.0 >Will a statement like > "EXEC SQL update [tablename] set [columnname] = [expression] > where [columname] = [expression]" >ever set sqlca.sqlcode to SQLNOTFOUND (100) or does it ALWAYS set >sqlca.sqlcode to (0) (no error) even if no rows were updated. If the database is MODE ANSI, the sqlca.sqlcode is set to SQLNOTFOUND when no rows are processed by an INSERT INTO Table SELECT ..., a DELETE or an UPDATE statement. If the database is not MODE ANSI, sqlca.sqlcode is always set to zero in those circumstances. These rules have applied in most versions of ESL/C and the engines, certainly since version 4.00. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>