What is an archive view?

An archive view is a database view and triggers defined on a nonversioned table or feature class (collectively referred to as a dataset) that has been enabled for archiving. An archive view is created when you enable the dataset for archiving or when you enable SQL access on a nonversioned, archive-enabled dataset.

Archive views are used to perform insert, update, and delete operations on the underlying nonversioned, archive-enabled dataset. When you edit an archive view using SQL, the system fields that keep track of changes in the dataset are automatically updated, as are the ObjectID values.

The archive view does not automatically update globalID or GUID values. If your table contains a globalID or GUID field, you can use Next_GlobalID to insert a value to this field.

When queried, an archive view returns the current state of the underlying dataset. Therefore, if you want to use SQL to access archived records, query the table directly instead.

Note:

Archive views are not supported in DB2 on the z operating system or in PostgreSQL 9.0.x.