How to determine modulo of uniData file?

[frosty]

Is there a verb other than GUIDE which will tell me

the modulo of a (static hash) uniData file?

[John Horn]

FILEINFO will do it.

On Tue, Jan 7, 2014 at 2:08 PM, frosty <johntr...@gmail.com> wrote:

Is there a verb other than GUIDE which will tell me

the modulo of a (static hash) uniData file?

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms

[frosty]

Not for me, on uniData 7.2.9.  =':^{

:FILEINFO

Not a verb

[Steve Johnson]

Try FILE.STAT

:FILE.STAT VOC

File name                             = VOC

Number of groups in file (modulo)     = 101

Static hashing, hash type             = 0

Block size                            = 1024

File has 2 groups in level two overflow. Please resize.

Number of records                     = 3560

Total number of bytes                 = 187638

Average number of records per group   = 35.2

Standard deviation from average       = 6.9

Average number of bytes per group     = 1857.8

Standard deviation from average       = 476.8

Average number of bytes in a record   = 52.7

Average number of bytes in record ID  = 11.3

Standard deviation from average       = 46.8

Minimum number of bytes in a record   = 6

Maximum number of bytes in a record   = 682

Minimum number of fields in a record  = 1

Maximum number of fields in a record  = 25

Average number of fields per record   = 2.7

Standard deviation from average       = 1.3

The actual file size in bytes         = 286720.

Suggested resize modulo = 263.

:VERSION

    Module Name         Version   Licensed

UniData RDBMS............ 7.2     Yes

Connection Pooling....... 7.2     No

Device License........... 7.2     Yes

NFA...................... 7.2     No

RFS...................... 7.2     No

EDA...................... 7.2     No

727

Regards,
Steve Johnson

Progenixx, Inc.

[Richard Lewis]

But don't you have to wait for it to parse the entire file to get the results?

On UV, I prefer to use GROUP.STAT because it only has to parse a 'screen-lines' number of groups (or less) to see the mod, sep, and type:
>GROUP.STAT RBLTEST
 Type description= Hashed, entire keys are full range of ASCII characters.
 Bytes  Records     File= RBLTEST  Modulo= 1009  Sep= 1  Type= 18
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
     0     0
Press any key to continue...

Is GROUP.STAT available on uniData?

Best Regards,

Richard Lewis

[Symeon Breen]

FILEINFO is a unibasic function.

[David Hendershot]

On uniVerse you can do HASH.HELP, not sure if it works on uniData

[frosty]

FILE.STAT is just what the Dr. ordered. Thank you, Steve.