Re: Getting the ROWID of a UPDATE

Posted in 2005

Jonathan Leffler — Sat, 05 Mar 2005 04:18:12 GMT — source: Usenet: comp.databases.informix

JoeT wrote: > 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. Does ESQL/C count? You need to access the relevant element of sqlca.sqlerrd - that contains the last rowid 'accessed'. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/