RE: Another Question about variable length fields

Good article but it does not address the file size difference I am seeing

Maybe the DSPOBJD is showing the size including the full 1028 bytes of the
variable length field. Even though most of them fall below the VARLEN value
of 30

I just wanted to see before and after values of my file sizes so I can see
how much space it is truly saving me.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Wednesday, November 25, 2009 4:18 PM
To: Midrange Systems Technical Discussion
Subject: Re: Another Question about variable length fields


Hi John
Here is a web page that may be of interest
http://www.itjungle.com/fhg/fhg092408-story01.html

Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill



Alan Shore
<AlanShore@xxxxxx
om> To
Sent by: Midrange Systems Technical
midrange-l-bounce Discussion
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

11/25/2009 04:05 Subject
PM Re: Another Question about variable
length fields

Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>







Hi John
How did you update the file?

Its been a while since I looked into using VARLEN fields, but according to
my memory, the size of the field is in fact an extra 25 characters (I
think) more than the number of characters in the field
Saying that, it should still be less than the original



Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill



"John Allen"
<jallen@xxxxxxxxx
om> To
Sent by: "'Midrange Systems Technical
midrange-l-bounce Discussion'"
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

11/25/2009 03:53 Subject
PM Another Question about variable
length fields

Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






Maybe I am misunderstanding the variable length field concept.
I thought it could reduce my file size??

OK, I have a physical file with a field that has fixed length of 256
I change the file to have variable length field 1028 and the allocated
length of 30.
Most of the records have 0 - 10 bytes of data in the field (I may reduce
allocated size to 10)

I then updated the file so that the new file with the new variable length
field has data truncated to minimum length (stripped off trailing blanks)

I then compare the file size (using DSPOBJD) and the new file with the
variable length field is quite a bit larger then the old file with the
fixed
length field.

I expected to see a smaller object size?
Or am I looking in the wrong place to compare the before and after sizes?

John




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.