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.