IBM Mainframe Forum

If I have a cobol program containg insert,delete and update queries for a particular table,
How can i know the no. of modified rows after complete execution of the program?

An update statement can alter multiple rows as well in a single shot, so simply putting a counter each time I get SQLCODE as 0 shall not work.

If the UPDATE statement is successful, SQLERRD(3) is set to the number of rows that are updated.

*****EXEC SQL INCLUDE SQLCA END-EXEC.
01 SQLCA.
05 SQLCAID PIC X(8).
05 SQLCABC PIC S9(9) COMP-4.
05 SQLCODE PIC S9(9) COMP-4.
05 SQLERRM.
49 SQLERRML PIC S9(4) COMP-4.
49 SQLERRMC PIC X(70).
05 SQLERRP PIC X(8).
05 SQLERRD OCCURS 6 TIMES
PIC S9(9) COMP-4.
05 SQLWARN.
10 SQLWARN0 PIC X.
10 SQLWARN1 PIC X.
10 SQLWARN2 PIC X.
10 SQLWARN3 PIC X.
10 SQLWARN4 PIC X.
10 SQLWARN5 PIC X.
10 SQLWARN6 PIC X.
10 SQLWARN7 PIC X.
05 SQLEXT.
10 SQLWARN8 PIC X.
10 SQLWARN9 PIC X.
10 SQLWARNA PIC X.
10 SQLSTATE PIC X(5).

Ok?

ok so simply displaying SQLERRD I will come to the no. of rows that are affected.

Kal El wrote:ok so simply displaying SQLERRD I will come to the no. of rows that are affected.

... after each sql-statement.
if you want total of program, you need to add them somewhere.

Hello,

ok so simply displaying SQLERRD I will come to the no. of rows that are affected.

Keep in mind that you are interested in SQLERRD(3). As GuyC mentioned, you also have to code for totaling.