Getting the ROWID of a UPDATE

Posted in 2005

JoeT — 4 Mar 2005 11:19:50 -0800 — source: Usenet: comp.databases.informix

Hi... I hate to say this, but I'm trying to replicate a feature in Oracle (yuck!) that is actually quite useful. Oracle has a UPDATE ... RETURNING <field> INTO <token> optional syntax. I'm trying to find out if in Informix IDS, if I did do UPDATE to a SINGLE tuple, would there be some sort of indication in some internal table just what the ROWID is that I just updated? Note that I have to get this info in any way EXCEPT 4GL. TIA, Joe