How to determine modulo of uniData file?

668 views
Skip to first unread message

frosty

unread,
Jan 7, 2014, 3:08:13 PM1/7/14
to mvd...@googlegroups.com
Is there a verb other than GUIDE which will tell me
the modulo of a (static hash) uniData file?

John Horn

unread,
Jan 7, 2014, 5:43:06 PM1/7/14
to mvd...@googlegroups.com
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

unread,
Jan 7, 2014, 9:17:34 PM1/7/14
to mvd...@googlegroups.com
Not for me, on uniData 7.2.9.  =':^{


:FILEINFO
Not a verb

Steve Johnson

unread,
Jan 7, 2014, 9:33:45 PM1/7/14
to mvd...@googlegroups.com
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

unread,
Jan 7, 2014, 10:46:55 PM1/7/14
to mvd...@googlegroups.com
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

unread,
Jan 8, 2014, 6:27:51 AM1/8/14
to mvd...@googlegroups.com

FILEINFO is a unibasic function.

David Hendershot

unread,
Jan 8, 2014, 1:00:10 PM1/8/14
to mvd...@googlegroups.com
On uniVerse you can do HASH.HELP, not sure if it works on uniData

frosty

unread,
Jan 21, 2014, 5:55:27 PM1/21/14
to mvd...@googlegroups.com, ste...@progenixx.com
FILE.STAT is just what the Dr. ordered. Thank you, Steve.
Reply all
Reply to author
Forward
0 new messages