Interested to Buy Any Domain ? << Click Here >> for more details...
when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was
- 5 Answers
- 12047 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Mention the location where the output received from explain statement is stored.
Explain the function of data manager.
What is db2 and what is the use of db2 optimizer?
What is db2 stogroup?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the maximum size of varchar data type in db2?
Explain about rct in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is null in db2?
Which isolation level provides highest data integrity?
What are the benefits of using the db2 database?
What is a cursor in programming?
Is the primary key a clustered index?
Explain the function done by data manager?
How to execute stored procedures?
