Returning SQLCA values: How?

I have several stored procedures that do an update on a table, such as: update mytable set myfield = myvariable where mykeyfield = passed_arg. End procedure If no rows are found to match my argument, this is not considered an error, but shouldn't SQLCA.SQLCode be = 100? Or the other case, if the update works, is there any way to return the number of rows that were updated? I guess the short question is, how do I get values from SQLCA in my stored proc so I can return them to a user? My environment is a PowerBuilder front end and Informix 5.01 Please copy respnse to email. mferris@wwa.com Thanks! Matt Ferris