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

"And, as far as transferring flat files to heterogeneous environments goes, implied decimal positions seen with zoned decimal isn't going to be any easier than packed decimal. Both will need to go through a download tool to convert or something like CPYTOIMPF."

I have to disagree with that statement. FTP will automatically convert EBCDIC to ASCII. Therefore, EBCDIC zoned F1F2F3 automatically converts to ASCII 313233 but EBCIDC packed 123F does not convert to anything intelligent in ASCII.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Saturday, September 9, 2023 8:55 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: DB2 Table: Is there any valid reason to create a zoned decimal column?

Are people still using files without column definitions? Where they simply do a CRTPF MYFILE RCDLEN(256) and use RPG to define the field positions?
Otherwise I cannot fathom the glory of DSPPFM to find numerics.

And, as far as transferring flat files to heterogeneous environments goes, implied decimal positions seen with zoned decimal isn't going to be any easier than packed decimal. Both will need to go through a download tool to convert or something like CPYTOIMPF.

On Fri, Sep 8, 2023 at 4: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.