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

The only real reason I can think of is that DSPJRN is readable.
May not be an issue if you have a tool such as DBUJRN.

FTP maybe, but there are ways around that.

Personally I might suggest a recommendation to prefer packed over zoned.
But I don't think the difference is enough to mandate one or the other.

I'd concentrate on rules around DATE/TIMESTAMP, VARCHAR, NULL, and INTEGERS.

Charles

On Fri, Sep 8, 2023 at 2:25 PM Osborne, Wynn <
Wynn.Osborne@xxxxxxxxxxxxxxxxxx> wrote:

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.