RE: Storing Numeric Values in the Database

I pretty much exclusively use zoned. The only time I mess with packed is
when working with a piece of legacy BPCS code (and even then I use mostly
zoned). I use SQL via STRSQL, FROG, or iNav (depends on what I'm doing).
I use WRKQRY a lot (is this a taatool?, not sure... it was here when I
started and works GREAT for lots of stuff... I think it is because I see
lots of other qry references that don't mention it). Anyway... zoned is
easy to read and easy to use and I have yet to have a problem with
performance. Storage is cheap, so storing packed instead of zoned to save
a few bytes seems silly (unless you are storing petabytes of information
maybe).

Now, I'm self taught (on the job) and zoned always felt more natural
(coming from c++ in college) than trying to work with packed. I don't
work with multiple CCSID's so that concern has never come up. Easy to
read, easy to use...


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
--- This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us and destroy this message immediately. ---