Concept of dating history


19-Oct-2017 00:42

Correct History is the most powerful of action types. You can view, change, and insert rows of data regardless of the effective date.You want to be careful of whom you give this option to within your company.With Update/Display, you can view only current and future rows—you can’t access history. But, as with Update/Display, you can update only existing future-dated rows.You can insert new rows with an effective date greater than or equal to the date on the current row. And you can insert new rows with an effective date greater than or equal to the current row.Is defined as the row with the most recent effective date, closest to the system date without going over.

If you are familiar with computer programming terminology, you can liken dating to a sub-routine that has been added to the system of courtship." (Friendship "with benefits" is a contemporary example.) Closely related to this is the invention of birth control.There is too much that could be said here, so I'll be brief.You can retrieve information without knowing any effective dates.

Effective dating allows you to attach a time reference to the data.

You use the action of Add to create new rows with new search keys in a table.