RE: Leading Zeroes in PF

Three fields, the first two being 5 bytes and the third being 4 bytes, for a 
total of 14 bytes.  If you pack the fields, you would cut 2 bytes for each 
of the first two fields and 1 on the third for a total of 5 bytes.  are we 
in agreement so far?

You are talking 35% of the total size, I am sure for some that is not a big 
deal, but I would love to save it if I could.



On Thu, 2 Feb 2006 15:15:54 -0500, Wilt, Charles wrote
> 1.3 gigs....
> 
> Not something I'd be real concerned about given that it would be a small
> portion of the total size.  I mean what's the total record size?
> 200-300 bytes?  You're talking about an extra 1%.
> 
> Charles Wilt
> --
> iSeries Systems Administrator / Developer
> Mitsubishi Electric Automotive America
> ph: 513-573-4343
> fax: 513-398-1121
> 
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Douglas W. Palme
> > Sent: Thursday, February 02, 2006 2:16 PM
> > To: Midrange Systems Technical Discussion
> > Subject: RE: Leading Zeroes in PF
> > 
> > Well considering we are talking about over 700 million 
> > records here, I'd say 
> > 2 bytes adds up :)
> > 
> > 
> > 
> > On Thu, 02 Feb 2006 10:49:12 -0700, michael wrote
> > > Saving 2 bytes for a 5 digit zip or 4 bytes for a 9 digit 
> > zip? That's
> > > not enough to care about...
> > > 
> > > > -------- Original Message --------
> > > > Subject: RE: Leading Zeroes in PF
> > > > From: "Douglas W. Palme" <dpalme@xxxxxxxxxxx>
> > > > Date: Thu, February 02, 2006 12:29 pm
> > > > To: Midrange Systems Technical Discussion 
> > <midrange-l@xxxxxxxxxxxx>
> > > > 
> > > > That is exactly why I wanted to use it, cut down the 
> > amount of disk 
> > space 
> > > > needed by using a packed field....I guesss I could have 
> > done a better 
> > job 
> > > > explaining that.
> > > > 
> > > > 
> > > > On Thu, 02 Feb 2006 10:18:29 -0700, michael wrote
> > > > > Don't work with Canada, eh?
> > > > > 
> > > > > What do you mean about being possible with the PF? PF's 
> > can have packed
> > > > > fields, and if you want to treat the zip code as 
> > numeric, it can be
> > > > > packed.
> > > > > 
> > > > > > -------- Original Message --------
> > > > > > Subject: Leading Zeroes in PF
> > > > > > From: "Douglas W. Palme" <dpalme@xxxxxxxxxxx>
> > > > > > Date: Thu, February 02, 2006 12:07 pm
> > > > > > To: "Mid Range List" <midrange-l@xxxxxxxxxxxx>
> > > > > > 
> > > > > > I have been working with some zipcode files and we 
> > would prefer to 
> > treat 
> > > > the 
> > > > > > field (zipcode) as a packed field, but I need to 
> > allow for leading 
> > > > > > zeroes...is that possible with the PF? 
> > > > > > 
> > > > > > If you bought it, it was hauled by a truck - 
> > somewhere, sometime.
> > > > > > 
> > > > > > -- 
> > > > > > 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.
> > > > 
> > > > 
> > > > If you bought it, it was hauled by a truck - somewhere, sometime.
> > > > 
> > > > -- 
> > > > 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.
> > 
> > 
> > If you bought it, it was hauled by a truck - somewhere, sometime.
> > 
> > -- 
> > 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.


If you bought it, it was hauled by a truck - somewhere, sometime.