How to find updated row count?

Navi · #1 (**permalink**) 04-26-10, 07:53

Code:

update t_tax 
set desc = paDesc
where code = paCode;

need a help on Informix!!!

is there any mechanism to find updated row count Ex:- in Oracle SQL%ROWCOUNT

bigcalm · #2 (**permalink**) 05-01-10, 18:13

sqlca.sqlerrd[2]

See IBM Informix Dynamic Server v10 Information Center

Of course, if you're separated from the database with a few layers of abstraction, it can be difficult to get this value. Check your driver documentation.

Navi · #3 (**permalink**) 05-02-10, 05:37

Thanks for the reply I'm using Informix 7.3 so I use this method

dbinfo('sqlca.sqlerrd2')

Internet Services

Web Development

Digital Marketing

Consumer Tech