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
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 |
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 |
What is a db2 collection?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
How would you find out the total number of rows in a db2 table?
When would you prefer to use VARCHAR?
What is db2 catalog database?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
can we view the access paths created by dbrm ? how ? thx
Is db2 free?
How do you check for a null value in a db2 column?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,