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

If you have zoned decimal defined in your DDS and want to convert to
packed, change your DDS source's numerics to packed (or binary) and then
CHGPF (your_file) SRCFILE(your_DDS_source). This technique has been handy
in data migrations where large history files with mostly numeric data have
been FTP'ed in; once the final cutover was done, I'd CHGPF (thereby
reducing the data size by about 40%) and recompile. Or do it with SQL and
ALTER TABLE.

On Sat, Sep 9, 2023 at 9:32 AM <smith5646midrange@xxxxxxxxx> wrote:

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

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


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