Re: DB2 Table: Is there any valid reason to create a zoned decimal column?

[Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>]

The difference in performance and storage is almost not measurable any longer.  Back in the 70s, they yea we couldd measure it.
--
Jim Oberholtzer
Agile Technology Architects




> On Sep 8, 2023, at 3:55 PM, Troy Hyde <troy.hyde@xxxxxxxxxxx> wrote:
>
> DSPPFM is THE reason that we define ALL numeric data as zoned.  Good luck trying to search for a specific value in packed numbers.
>
> I'm aware of the trade-off in performance and storage but it's a good trade for us.
>
> T
>
> On 9/8/2023 2:37 PM, James H. H. Lampert via MIDRANGE-L wrote:
> > On 9/8/23 1:25 PM, Osborne, Wynn wrote:
> > > This question arose within me while putting together some database standards for my team.
> > > I cannot think of valid reason why I would ever this
> >
> > Readability from extreme low-level tools like DSPPFM, or EDTF?
> >
> > -- 
> > JHHL
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.