Informix: How to get the rowid of the last insert statement <p>This is an extension of a question I asked before: <a href="http://stackoverflow.com/questions/3857444/c-how-do-i-get-the-id-number-of-the-last-row-inserted-using-informix">C#: How do I get the ID number of the last row inserted using Informix</a></p> <p>I am writing some code in C# to insert records into the informix db using the .NET Informix driver. I was able to get the id of the last insert, but in some of my tables the 'serial' attribute is not used. I was looking for a command similar to the following, but to get rowid instead of id.</p> <p><code>SELECT DBINFO ('sqlca.sqlerrd1') FROM systables WHERE tabid = 1;</code></p> <p>And yes, I do realize working with the rowid is dangerous because it is not constant. However, I plan to make my application force the client apps to reset the data if the table is altered in a way that the rowids got rearranged or the such.</p>