Progress Question:
Download Questions PDF

Explain what are the scenarios or situations under which Progress Database creates new index entry for a record?

Answer:

As you work with your application, you will want to know when Progress creates and updates indexes. Progress creates a new index entry for a record at the first occurrence of any one of the following:

-At the end of a statement in which Progress assigns values to all components of the index entry.
-At the end of the closest iterating subtransaction block in which the Progress 4GL creates the record.
-When Progress processes a VALIDATE statement.
-When Progress releases the record from the record buffer.
- At the end of the transaction in which Progress creates the record.

Progress updates an index at the end of any statement in which it changes the values for one or more index fields. Because Progress updates indexes immediately (at the end of an UPDATE statement), Progress immediately FINDs records in the order of the new index, while the data in the found record is unchanged. Progress changes the data in the record at the end of the scope of the record or when it releases the record.

Note: Progress does not update an index if the value you try to assign to the index field is the same as the current value of the index field. You can change the name of an index at any time.

You can also delete nonprimary indexes. However, before letting you delete a primary index, OpenEdge requires that you first designate another index as primary.

If there is only one index, you must create a new index before deleting the existing index. You cannot change any of the component definitions of an index. Instead, you must delete the index and re-create it using the modified component definitions.

Remember that OpenEdge assumes that the first index you create is the primary index, so create your primary index first. Using the 4GL

Download Progress Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know what is the option used to find out which index is used by Progress for a particular query?Tell me what are the steps and needed resources for connecting to a Progress Database?