Get_LH_Info Function
Description
Retrieves Linear Hash Information for a specific LH table.
Syntax
info = Get_LH_Info(tablename)
Parameters
The function has the following parameters:
| Parameter | Description |
|---|---|
| tablename | The linear hash tablename. |
Returns
| Value | Description |
|---|---|
| Number of Frames (Modulo) | The number of frames in the table. |
| Frame Size | The frame size used by the table. |
| Percent | The current percentage of the primary frame. |
| Number of Records | The number of records (rows) in the table. |
| Sizelock | The sizelock value of the table. A value of 0 allows for expansion and contraction of the file, a value of 1 allows for the expansion only and a sizelock of 2 prohibits both expansion and contraction. |
| Size Threshold | The threshold percentage for each frame in the table. |
| Operating System Filename | The OS path and filename of the LH table. |
| File Version | The designation of the driver which created the file. Value Description 0 - Old AREV systems. 1 - Non-Universal Drvier Network Products. (NT Service 1.5, NLM 5.0, etc.) 2 - The Universal Driver. |
Example
declare function Get_LH_Info
lhInfo = Get_LH_Info("CUSTOMERS")
/* This should return:
lhInfo<1> should be "3"
lhInfo<2> should be "1024"
lhInfo<3> should be "76"
lhInfo<4> should be "20"
lhInfo<5> should be "0"
lhInfo<6> should be "80"
lhInfo<7> should be "EXAMPLES\REV53002.LK"
lhInfo<8> should be "2"
*/