check for the value is in sqlerrd(3). it contains the no. of rows updates

How can you quickly find out the number of rows updated
after an update statement?

Question Posted / vamshi

Answer Posted / vamshi

check for the value is in sqlerrd(3). it contains the no.
of rows updates.

Is This Answer Correct ?

23 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a system catalog table in db2?

1245

What is null in db2?

1069

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1152

What is difference between isnull and coalesce?

1107

Mention the downsides of page level lock.

1217

What is db2 command?

1091

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1134

What parameters are used to control the free space in DB2?

1096

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3637

How to find the maximum value in a column in the db2 database?

1130

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1237

what is the role of the cursor in db2?

1112

Is db2 a database?

1028

What is a buffer in memory?

1110

How do I import data from excel to db2?

1129