Common archive fields

You can archive data that is derived from the values stored in fields associated with database, OpenEdge, or system tables. An additional set of archive-specific fields for which unique values are defined during the archiving process is also generated for, and stored with, each archived table.

Table 3–13 and Table 3–14 define the unique fields associated with each database or system table. Table 3–16 identifies the common fields for which values are generated and added to a table when you archive it.

Table 3–16: Common archive fields
Field name
Data type
Description
_ArchiveType
Character
Identifies the field's archive type:
  • H — Hourly
  • D — Daily
  • W — Weekly
_Length
Integer
Number of seconds for the archive to take place.
_StartDate
Date
Start date for the row. This date will always be the same as the end for hourly and daily.
_StartTime
Integer
Start time for the row.
_EndDate
Date
End date for the row.
_EndTime
Integer
End time for the row.
_Transactions
Integer
Number of transactions committed.
_RecordCount
Integer
Number of records in this archived file.
Resrc_ID
Integer
The Resource ID of the database for this site.
Site_ID
Character
The Site ID for the database.


Copyright © 2008 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095