Getting the Count or Rows Updated

stuckonsox · #1 (**permalink**) 03-17-06, 15:21

I am using the Unix db2 command line tool (actually in a shell script).

Is there an option I can turn on that will tell me the number of rows affected by an update statement?

for example my sql would be very basic like:

Code:

update EMAIL_ADDR set NAME_EMAIL_ADDR = 'test2@testdomain.com' where id_email_addr = 200

The info I get back is:

Code:

update EMAIL_ADDR set NAME_EMAIL_ADDR = 'test2@testdomain.com' where id_email_addr = 200
DB20000I  The SQL command completed successfully.

The jist of my shell script is:

Code:

db2 "connect to $DATABASE user $USERID using '$PWD' "
db2 +c -tvf $INFILE | tee $RESULTFILE

Marcus_A · #2 (**permalink**) 03-17-06, 18:47

If you use the -a CLI parm you will get the entire SQLCA. The number of rows affected is in sqlerrd(3).

In a procedure you can use the GET DIAGNOSTICS SQL statement to get the ROW_COUNT into a variable, but I don't think that works in CLI.

Internet Services

Web Development

Digital Marketing

Consumer Tech