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.
|
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"
*/
1 Comment
Don Bakke
The above description of what is returned is how it appears in the Programmer's Reference Guide. The documentation does not make it clear that each value is a different attribute (@FM delimited) in an array variable that is returned. The Example code makes this a little clearer.