Find Command

, , ,
1

I am trying to access Adabas database file using Natural program. I am using FIND command to fetch the records from Adabas DB using the descriptor (key). When I am doing so, I can see same data fetched more than 1 time. I want to know the reason,

  1. why same data is fetched multiple times, when the table cannot have duplicate values.
  2. How do we overcome this issue.

Thanks.

2

You do not seem to understand Adabas at all.

All fields, including descriptors, can have duplicate values.

For example; surname could be a descriptor field, and there might be multiple records with the surname Natarajan.

There is an option to specify a descriptor field has unique values, but that is something usually done by a DBA, not a programmer.

3

When reporting the records, include the ISN field. Each ISN represents a unique record.

FIND file WITH descriptor = value
  DISPLAY *ISN descriptor

If the ISNs are different, then you were mistaken in thinking the descriptor values are unique (“the table cannot have duplicate values”). If the ISNs are duplicated, then a descriptor component is from a multiple-occurring field, and the same record is being returned multiple times.

1 Like