MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » January 2014

Re: Philosophical question...define table to be load from external data with integer or decimal fields...



fixed

On 1/22/2014 12:51 PM, Charles Wilt wrote:
I'm creating a new table to hold data received from an external
source.

So MyField is a 5 digit number...

I could defined this as Packed/Zoned 5,0 Or I could use integer (or
even small integer since the current number of values is less than
1000)

Since I know DB2 and RPG for that matter perform best with integer,
I'm leaning that direction. But I can't help but think that Packed
(5,0) is more correct.

I use this technique extensively to send data back & forth between RPG code and Java code.

For maximum flexibility, I suggests using zoned. This way your consumer can handle the data regardless of the language or environment.

IMO, performance shouldn't be a serious concern. The few extra microseconds you might get from using integer or packed shouldn't make a difference. If it does, you've got bigger problems.

david







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact