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

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.

 

Syntax 

GetTableStatHistoryHandle()