What is the Best READ

, ,
1

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?

2

Hi Ats,

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

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

This might help you.

Thanks,
Mishra

3

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.