Re: sqlca.sqlerrd [31509]

OK, if sqlca.sqlerrd[2] is zero then no rows were updated. By ANSI Standard rules, it is not an error to update zero rows nor to delete zero rows so this is the only way to know that your update didn't do anything - check the count in sqlca.sqlerrd[2] to see if the number of rows you expected to update matches that. Art Art S. Kagel, Principal Consultant Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Sep 25, 2013 at 11:11 AM, CHUAN LU <luchuan@cn.ibm.com> wrote: > HI, > > a customer write a multithread application to update some record in the > same > table, per thread update some records. they found the update sql execute > successful.bu the sqlca.sqlerrd[2] (row) is zero . why? if they justly ran > only one update sql ,the sqlca.sqlerrd[2] (row) is large than zero. > thanks for your time. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c26456f58af604e739700d