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

Figuring out the actual From/To positions in record formats and data
structures is easier when Zoned is used.

Rich
Pro Race Timing

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Osborne, Wynn
Sent: Friday, September 8, 2023 2:25 PM
To: 'midrange-l@xxxxxxxxxxxxxxxxxx' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: DB2 Table: Is there any valid reason to create a zoned decimal
column?

Hi all,

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

What about you? Have you come across a scenario where this was good choice?

Regards,

Wynn Osborne
Senior IBM i Programmer-Analyst,Database Administrator The Villages


--
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.