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

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

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.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].