Row size in a Hash file

[pajj]

Where can I find documentation to help me determine the different data types size allocations in a Has file. For example I have a hash file with the following row structure:

field1 decimal 10
field 2 varchar 2
field 3 numeric 4

I need to find a document that will help me determine how much space each row will consume in bytes.

tks

[DSguru2B]

I doubt there is a document for this manipulation per se, but you can make an educated guess. Add all the lengths up and add a few bytes to it. Ray has that info posted here somewhere. This will give you a good estimate of your row size.
I also advise searching the archives, on keywords like "calculate row size" and its alike.

[ray.wurlod]

There are no data types - everything is stored as string. Add together the lengths, add one byte per field (the inter-field delimiter) then add fourteen bytes per record storage overhead (or twenty-two bytes per record storage overhead for 64-bit hashed files). In your example, that would be 16 + 2 + 14 = 32 bytes per record.