Re: Leading Zeroes in PF -- MIDRANGE-L

This reminds me of a problem in 2000... we don't need no stinkin'
century....

On 2/2/06, Douglas W. Palme <dpalme@xxxxxxxxxxx> wrote:
>
> 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.
>
> --
> 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.
>
>


--
Mike Wills
koldark@xxxxxxxxx
http://mikewills.name
http://theriverbendpodcast.com

"There are 10 types of people in the world: those who understand binary, and
those who don't." -Unknown