Explain what are the scenarios or situations under which Progress Database creates new index entry for a record?
Submitted by: AdministratorAs 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
Submitted by: Administrator
-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
Submitted by: Administrator
Read Online Progress Job Interview Questions And Answers
Top Progress Questions
☺ | Tell me what is metaschema in Progress Database? |
☺ | Explain what are the vital features of Progress database? |
☺ | Explain what are the similarities and differences between progress and SQL? |
☺ | Tell me what are the steps for connecting to Progress database in a Linux environment? Is this possible or in other words does Progress database support Linux? |
☺ | Tell me what is the vital and real strength of progress database? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Sybase Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |