Number of rows deleted while deleting data thru Job

Madhan Mohan Pendyala · New User Joined: 18 Mar 2008 Posts: 6 Location: Hyderabad

when deleting data in the table through job, which statement in the job should be specified which gives the number of rows deleted.

Gnanas N · Posted: Mon Mar 31, 2008 7:49 pm Post subject:

Displaying number of rows updated.
You can display the number of rows affected by an SQL Insert, Update or Delete by displaying the value of SQLERRD(3).

Madhan Mohan Pendyala · New User Joined: 18 Mar 2008 Posts: 6 Location: Hyderabad

Hey, Thanks for the Info.
When we execute SPUFI, SQLERRD(3) will have the number of rows effected. In this case, I'm deleting the data thru job. How can we use this SQLCA variable here?

the_gautam · Posted: Mon Mar 31, 2008 10:18 pm Post subject:

To get the number of rows affected by a query in the COBOL program, we may use SQLERRD(3) as mentioned by gnanas.

the other method is

EXEC SQL
GET DIAGNOSTICS :rcount
END-EXEC