Any way to see how many rows were updated?

Fumigator · #1 (**permalink**) 04-02-07, 18:42

MySQL (in PHP) has a function mysql_affected_rows() which returns the number of rows that an update or delete query affected. Is there a comparable function in DB2?

sathyaram_s · #2 (**permalink**) 04-02-07, 19:56

db2_num_rows()

Sathyaram

Quote:

Originally Posted by Fumigator

MySQL (in PHP) has a function mysql_affected_rows() which returns the number of rows that an update or delete query affected. Is there a comparable function in DB2?

db2udbgirl · #3 (**permalink**) 04-02-07, 21:19

But I think db2_num_rows is available only on DB2 V9. Is there is any other equivalent on DB2 V8 ?

umayer · #4 (**permalink**) 04-03-07, 01:56

Check the SQLCA.
Field SQLERRD(3) contains the number of affected rows after an INSERT, UPDATE or DELETE statement.

db2udbgirl · #5 (**permalink**) 04-03-07, 09:10

I'm sorry I don't understand much from your comment. It would be of great help if you can provide me any handy URL if you have which explains about SQLCA.

Thanks.

rahul_s80 · #6 (**permalink**) 04-03-07, 10:07

ckh for
get diagonistic statement

GET DIAGNOSTICS v_row_inserted = ROW_COUNT;

stolze · #7 (**permalink**) 04-03-07, 10:35

Another alternative is to simply select the results:

Code:

SELECT COUNT(*)
FROM NEW TABLE ( UPDATE ... ) AS t

Fumigator · #8 (**permalink**) 04-03-07, 12:59

Quote:

Check the SQLCA.
Field SQLERRD(3) contains the number of affected rows after an INSERT, UPDATE or DELETE statement.
Reply With Quote

Ahh, that's the ticket. As soon as you said that, I remembered doing it back around 1994. Thanks!

umayer · #9 (**permalink**) 04-04-07, 01:33

Quote:

Originally Posted by db2udbgirl

I'm sorry I don't understand much from your comment. It would be of great help if you can provide me any handy URL if you have which explains about SQLCA.

Check the SQL-reference for more information.

http://publib.boulder.ibm.com/infoce...bknrsqlc999499

Internet Services

Web Development

Digital Marketing

Consumer Tech