Good morning. I've got one of these wonderful, "It worked great in development, but not in production!" issues..

First of all, here's my source where the problem appears to be:

else;                                                             
  // clear temp file and write associated line numbers to the file
  exec sql delete  from mlabulkopf;                               
                                                                  
  sqlstmt2='insert into mlabulkopf select sdlnid from ' +         
           %trim(datalib) + '/f4211j1 where sdkcoo = ''' +        
           o_sdkcoo + ''' and sddoco = ' + %char(o_sddoco) +      
           ' and sdktln = ' + %char(o_sdlnid);                    
(The joblog says that it can't find MLABULKOPF even though it is definitely in the job's libl)

                                                                   
  exec sql prepare workfile from :sqlstmt2;                       
  exec sql execute workfile;                                      

  // prepare sql statement for master skus                        
  sqlstmt = 'select $i$oes, $i$sdj, $i$uev +                      
            from ' + %trim(datalib) + '/f56100 +                  
            join mlabulkopf on mllineno=$ilnid where $ikcoo=''' + 
            o_sdkcoo + ''' and $idoco=' + %char(o_sddoco) +       
            ' and $idcto = ''SB'' and $ilotn=''' +                
            %trim(o_sdlitm) + ''' and $i$oes not +                
            in (''N'',''O'') +                                    
            order by $i$oes, $i$sdj for read only';               
endif;                                                            
                                                                  
// prepare, declare and open availability cursor                  
exec sql prepare availability from :sqlstmt;                      
exec sql declare c2 cursor for availability;                      
exec sql open c2;      

dow sqlcod = 0;                                         
                                                        
  // fetch next available f56100 record                
  exec sql fetch next from c2 into :a_$i$oes, :a_$i$sdj,
             :a_sumqty;                                

more code follows fetch

In the joblog, the first thing I see is a message that says :

MESSAGE . . . . :   CONVERSION ERROR IN ASSIGNMENT TO HOST VARIABLE A_SUMQTY
CAUSE . . . . . :   DURING AN ATTEMPT TO RETURN A VALUE TO HOST VARIABLE   
  A_SUMQTY ON A FETCH, AN EMBEDDED SELECT STATEMENT, A CALL STATEMENT, A SET
  STATEMENT, A SET DESCRIPTOR STATEMENT, OR A VALUES INTO STATEMENT, ERROR 
  TYPE 1 OCCURRED. A LIST OF THE ERROR TYPES FOLLOWS: -- ERROR TYPE 1 IS   
  OVERFLOW. --

Does this mean that the a_sumqty was greater than the 7.0 variable allows?

This is now in production and cannot be backed out, so any help would be greatly appreciated.

Thanks!