Next ❯❮ Previous

Suppose If i have updated few fields of Adabas file using UPDATE command, and after that i used display to see that field get updated or not. If in Display it showing nothing or record did not get updated then what can be the possible reasons?

Submitted by: Administrator
The find instruction may b used to display such that we
applied find command to get the records corresponding to
our search entry and after that record might me updated.So
the updated inverted list will be formed but the ISN list
in the working storage section will not be updated giving
the same records prior to updation.
Submitted by: Administrator
you are not using END TRANSACTION command to commit the updates
Submitted by: Vikas
The developer might have not mentioned the END TRANSACTION and COMMIT key word which stores the data.
Submitted by: Sajith
There could be two cases.
1. If you use update and display in the same find loop then the data wont display with the updated details, because your find query was before update and the data is retrieved to local view already.
2. If you update using any field using UPDATE command in NATURAL/ADABAS, then you need to give END TRANSACTION command after UPDATE statement. END TRANSACTION will commit your UPDATE to the database.
Then write a new query program to find the record for checking updated values.
Submitted by: Kk
Next ❯❮ Previous
Read Online IBM ADABAS Job Interview Questions And Answers