MVSFORUMS.com

suma · Beginner Joined: 23 Jan 2006 Posts: 65 Topics: 29

Hi all,

Is it possible to count number of records deleted after successfull deletion records from a DB2 table using DELETE sql command.

thanks
Suma

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Suma,

After the succesful execuetion of the sql Check for SQLERRD(3) from SQLCA. It will contain the no. of the rows deleted/updated like below. Here 5 rows are deleted.

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

Hello Suma,

unfortunately, the number of rows implicitly deleted due to ON DELETE CASCADE defined relations for referential integrity are not reflected in the above mentioned counter.

Furthermore, if you execute a DELETE statement without a WHERE clause, then this counter is set to -1 , since otherwise the delete itself would consume too much ressources.

redards
Christian