Embedded Sql problem

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

I have a SQL statement that i developed using interactive SQL.  I get
the results that i'm looking for.  I then took this SQL and embedded it
into an RPG application. 
I no longer get the results that I am expecting.  I put the program into
debug and copied by select statement directly from the rpg and pasted it
back to interactive sql(just to be sure that i didn't miss type. )
Again i get the results i'm expecting.  I've tried changing the (allow
copy of data) parm on the compile from yes, to no and back to *optimize.
Same results.  
 
here are the results i'm looking for. 
 974706   D4                
 908231   I8                
 908232   I8                
 913235   I8                
 913236   I8                
 
I don't get the record with the D4 when embedded. 
 
Here is the SQL statement. 
The D4 record from above exists in SCMS but not in UPRM. 
 
select * from SCMS Left outer join UPRM on SMPRM = UPPRM join SOCD  
on SMSCD = SCSCD where SMCLO = ' ' and SMSDT = 20031111             
and SMCRW in ('RG', '00170','00540','00560','00570', '00580','00590'
,'00710', '00840','00890', '01050','01140','01190','01310','01330', 
'01488', '01600',' ')           
 
Any idea why this will work interactively but not embedded?
 
Thanks 
 
Mike