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

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.