What is the Best READ

Hi All,

I would like to know what READ type would be the best option if we are required to update more than 70-75% of database records. What are the advantages of it?

Hi Ats,

Kindly refer to the following topic in Adabas one of the Adabas threads.

I found it interesting
http://tech.forums.softwareag.com/viewtopic.php?t=6076&fstart=50&sid=133fa5abbbbffc5f119ea60a656f387c

This might help you.

Thanks,
Mishra

READ LOGICAL, READ PHYSICAL and READ BY ISN can be used for mass updates in different situations. It depends on the data.

Some general advice:

If you’re reading the entire file and rejecting a portion of the records, use READ BY ISN. It avoids several issues related to the alternatives, but still allows you to build-in restart logic.

If you’re using a descriptor to specify the selection criteria, use READ LOGICAL.