Re: Binary fields in DB2 and RPG

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

Uhh... perhaps I am just misreading this... you mean RPG declares the 
integer field as 9B0, right?

create table wtf (val int)
insert into wtf values(1234567890)
select * from wtf

you get back the 1,234,567,890


Joe Pluta wrote:
> This is sort of an RPG thing, but really more of a DB2 issue, which is 
> why I posted it here.
>
> Dave Odom ought to love this.  It may have been discussed before, but I 
> didn't find it.  Anyway, if you declare a field in SQL as type INT, it 
> is actually declared in DB2 as a 9B0 field.  This is fine right up until 
> the time you try to write a value over 999,999,999.  For example: 
> 1,198,368,000, which is the number of seconds between January 1, 2008 
> and January 1, 1970.
>
> Such joy.
>
> Joe
>