esql-c update return code

I would like to update a row in a table and if not found, insert the record. The return value of update (sqlca.sqlcode) returns a 0 when the record is not found. I thought it should return 100 just like a select statement. Is this a bug? Now I have to do a select first. I am using Informix On-line 5.0 Any advice appreciated. -- Chaiw Kok Kee Consultant Multi-Purpose Information Technology kkchaiw@mit.com.my www.jaring.my/mphb/