SQLRPGLE module fails on large value in INTEGER column

We have a failing SQLRPGLE module.  It's getting overflow error (MCH1210) when 
fetching a row that has an integer column whose value is > 999,999,999.  
Inspecting the compile listing I see that the SQL temporary variable generated 
is defined a type BINARY, thus the overflow.  The database field is defined in 
an external DS: 

H extbinint( *yes ) 
D LFOID                         10I 0 

but the SQL-generated field is BINARY: 

D  SQL_00051           6454   6457B 0 

so the move generated by the FETCH fails: 

c*exec sql          fetch from log_item_list 
c*                  into :LFOID:lf_null_ind 
C                   EVAL      LFOID = SQL_00051 

This seems like a bug in SQL pre-compiler.  It is generating code that cannot 
handle the full range of values for database columns of type INTEGER.


The module is compiled on V5R3 with target release V5R2.  The production code 
will be compiled on V5R2 with target release (*CURRENT).  
 

                
---------------------------------
Yahoo! Music Unlimited - Access over 1 million songs.Try it free.