when we are trying to update db2 rows. if the program
abends . how we will know that the last successful update
row was
Answer Posted / 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 |
Post New Answer View All Answers
What is rct?
What is commit in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is the default page size of buffer pools?
can we view the access paths created by dbrm ? how ? thx
How will you return the number of records in table?
What parameters are used to control the free space in DB2?
How to compare data between two tables in db2?
What is temporal table in db2?
What is the maximum size of a char data type in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
How and when does the db2 enforces the unique key?
What is dclgen (declaration generator)?
What is runstats and reorg in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?