Re: SQL problem

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

it's the like... use a varying length field.

The select (based on a fixed field POSTCAT) is for '7 Frank', then some
number of characters (%), _THEN_ a specific number of blanks as
specified by the fixed length field (the POSTCAT field).


On Thu, 2006-01-26 at 10:16 -0500, Smith, Mike wrote:
> I am having a problem with an embedded SQL statement.  
> I can run the following from STRSQL and it will return results. 
> SELECT SOSST, SOSH#, SOCTC  from  SRVOUT00 WHERE SOSAD like '7 Frank%
> '             
> 
> However, I am trying to run a Select into inside a program without
> success.  
> Here is what I have 
> 
> C/EXEC SQL                                                     
> C+ SELECT SOSST, SOSH#, SOCTC INTO :Street, :house, :city FROM 
> C+ SRVOUT00 WHERE SOSAD like :POSTCAT                          
> C/END-EXEC        
> 
> After executing I receive a SQLCOD = 100  The value of :POSTCAT is
> POSTCAT = '7 Frank%                                          '
> 
> 
> Any ideas?
> 
> 
> Michael Smith
> iSeries.mySeries.
>