# Browsing adabas file

**URL:** <https://techcommunity.softwareag.com/t/browsing-adabas-file/254331>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Natural-on-Mainframes\
**Created:** [January 6, 2022, 6:22pm UTC](https://techcommunity.softwareag.com/t/browsing-adabas-file/254331 "2022-01-06T18:22:16Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Javier\_Gonzalez2](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/javier_gonzalez2/32/6988_2.png) [@Javier\_Gonzalez2](https://techcommunity.softwareag.com/u/Javier_Gonzalez2)\
**Post date:** [January 6, 2022, 6:22pm UTC](https://techcommunity.softwareag.com/t/browsing-adabas-file/254331/1 "2022-01-06T18:22:16Z")

</div>

Hello.  
I need a reference to browse properly an Adabas file while other user can delete records.  
About 99.999 records can be listed and I need to show page numbers  
Any tip ?

---

<div class="post-metadata">

**Author:** ![wolfgang.winter](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/wolfgang.winter/32/17954_2.png) [@wolfgang.winter](https://techcommunity.softwareag.com/u/wolfgang.winter)\
**Post date:** [January 6, 2022, 7:38pm UTC](https://techcommunity.softwareag.com/t/browsing-adabas-file/254331/2 "2022-01-06T19:38:18Z")

</div>

Reading a file while others are deleting is just as much a no-brainer as is pagination, so you’ll need to describe in a bit more detail where you see issues.

For example: does it always need to show the “correct” relative records, i.e. when you flip from page 2 to 3 and someone deletes a record previously displayed on page 1, what do you expect ?

The usual (safe) approach is to keep track of the last key value (or ISN) for every page and just read a chunk of data matching the number of records displayed on a single page and reposition while you page forward / backward.

If you are looking for an up-to-date display at any time you will need to re-read all records from start to page ‘n’ when flipping to the next / previous page.

---

<div class="post-metadata">

**Author:** ![Javier\_Gonzalez2](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/javier_gonzalez2/32/6988_2.png) [@Javier\_Gonzalez2](https://techcommunity.softwareag.com/u/Javier_Gonzalez2)\
**Post date:** [January 9, 2022, 10:52am UTC](https://techcommunity.softwareag.com/t/browsing-adabas-file/254331/3 "2022-01-09T10:52:59Z")

</div>

Thank very much.  
Not only DELETE even STORE ADABAS COMMANDS are included.  
As you comment, I will use the usual (safe) approach using a READ DDM WITH SPD starting with isn.  
I will include a PF-KEY to refresh data for first page.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 9, 2022, 10:53am UTC](https://techcommunity.softwareag.com/t/browsing-adabas-file/254331/4 "2022-04-09T10:53:09Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.