GetTableStatHistoryHandle( ) method

Returns the handle of the temp-table used for storing the archived statistics from the _TableStat virtual system table. The method returns the Unknown value (?) if the ArchiveTableStatistics property is set to FALSE.

Return type: HANDLE

Access: PUBLIC STATIC

Applies to: Progress.Database.TempTableInfo class

Syntax

GetTableStatHistoryHandle()

This method returns a table handle to the _TableStatHistory temp-table. This is maintained by the AVM and cannot be deleted when the ArchiveTableStatistics property is set to TRUE. If you try to delete it, the AVM raises an error. The _TableStatHistory dynamic temp-table can be deleted if the ArchiveTableStatistics property is set to FALSE.

The _TableStatHistory only contains information about temp-tables that were deleted during the session.

The records in this table can be manipulated by emptying the temp-table. If the ArchiveTableStatistics property is again set to TRUE, the dynamic temp-table _TableStatHistory is recreated. lt contains all the fields from _TableStat, except the _TableStat-id field.

The fields that will be present in the _Tablestat table are listed below:

_Table-name
A character field with the temp-table name.
_Proc-name
A character field with the name of the procedure in which the temp-table was created.
_Delete-Timestamp
The date-time field with the timestamp denoting when the temp-table was deleted.