when i am trying to update a table having 1000 rows. the
program abends.how we will come to know the last successful
updated row was. we are not using any commit operations

Answers were Sorted based on User's Feedback



when i am trying to update a table having 1000 rows. the program abends.how we will come to know t..

Answer / sesha

If there is no commit is mentioned,processed records are
lost when an abnormal end occurs.Rows are inserted,
updated,deleted in a table, those changes will be
lost in case of abend.

Is This Answer Correct ?    7 Yes 0 No

when i am trying to update a table having 1000 rows. the program abends.how we will come to know t..

Answer / guest

check SQLERRD(3) from SQLCA copybook.

Is This Answer Correct ?    4 Yes 2 No

when i am trying to update a table having 1000 rows. the program abends.how we will come to know t..

Answer / girish kumar

if u want to update ur changes to the database, posible when the commit is executed or when the program successfully executed. none other any situation database will not update.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More DB2 Interview Questions

What do you mean by NOT NULL? When will you use it?

3 Answers  


What is the latest version of ibm db2?

0 Answers  


Describe what a storage group(STOGROUP) is?

2 Answers  


How can you classify the locks in db2?

0 Answers  


What is the advantage in De-normalizing tables in DB2?

0 Answers  






in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,


Give some example of statistics collected during RUNSTATS?

1 Answers  


What is subquery ?

6 Answers  


What does sqlcabc has?

0 Answers  


Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,


Explain how can you do the explain of a dynamic sql statement?

0 Answers  


What is the SQL Communications Area and what are some of its key fields?

1 Answers  


Categories