Int Size

 >>  If I create a table with a SMALLINT it is shown as being defined as
being 4 digits long.  I can insert a 5 digit long number via SQL but RPG
does not support this length of data.

It does - but not by default since the I and U data types were added long
after the database supported binary fields.  By default RPG maps binary
fields to type B and hence there is a limit of 4 digits in a 2 byte field.
Have you tried defining the field(s) "by hand" in your program with a 5I 0
definition?  I would have thought that would work.  On the latest release
you can deal with it by using the compiler directive EXTBININT(*YES).  This
forces the compiler to do things the way you want!!  I thought this came out
a release or two back - but it shows up as new for V5R2 so I guess I'm
mismembering - senior moments come far too often these days!

Jon Paris
Partner400