when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was

Answers were Sorted based on User's Feedback



when we are trying to update db2 rows. if the program abends . how we will know that the last succ..

Answer / jagan

In SQLCA , we have field named SQLERRD . In SQLERRD(3) , the
no of rows successful updated (or) inserted can be found .

Is This Answer Correct ?    15 Yes 2 No

when we are trying to update db2 rows. if the program abends . how we will know that the last succ..

Answer / vinay srivastava

We can go in Abend Aid and look for the source listing where
we can find the last values stored in Host Variables where
the Job Abended.

Is This Answer Correct ?    1 Yes 0 No

when we are trying to update db2 rows. if the program abends . how we will know that the last succ..

Answer / lenin

In cobol program, we can create one counter after each
successful update. So by checking the counter value we can
find out howmany rows are updated.

Please correct me if i am wrong..

Is This Answer Correct ?    1 Yes 1 No

when we are trying to update db2 rows. if the program abends . how we will know that the last succ..

Answer / ramesh m

You can do the select query and in where condition, you
have to query for current timestamp for the particular row.

Is This Answer Correct ?    1 Yes 2 No

when we are trying to update db2 rows. if the program abends . how we will know that the last succ..

Answer / prachi

check for sqlca.sqlerrd[2] -
as it indicates the number of rows processed before the
error occurred in a multirow INSERT, UPDATE, or DELETE
statement.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB2 Interview Questions

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,


What do you do to keep the cursor from closing after a commit?

1 Answers  


What is the difference between static and dynamic SQL?

1 Answers  


what is utility for parm lib

0 Answers   IBM,


What is universal database?

0 Answers  


How to select the duplicate rows from a table?

4 Answers  


What is a data page?

1 Answers  


A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,


Can we install 2 different versions of Db2 on same mainframe?

3 Answers  


What is the default page size of buffer pools?

0 Answers  


Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,


How does DB2 determine what lock-size to use?

2 Answers  


Categories