RE: SQLRPG with LIKE

[<SRamanujan@xxxxxxxxxxxxxxxxxx>]

Hi,
You might have to pad the field with '%' for LIKE keyword, so the match
can be found. You could try the following before your sql statement.

        Eval      %subst(fic:%scan(' ',fic))= *all'%'

So if FIC was '123   ', the above will pad the rest with '%' and it will
become '123%%%%%'.
HTH,
Sudha
        

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax
 

-----Original Message-----
From: Damien Spriet [mailto:damien.spriet@xxxxxxxxxxxxxxxxxxxx] 
Sent: Wednesday, November 17, 2004 8:17 AM
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: SQLRPG with LIKE

I'm trying to use LIKE in the SELECT on my SQLRPGILE pgm but it doesnt't
work why ? 
If I put equal works well. 

C* 
C *ENTRY PLIST 
C              PARM BIB 10 
C              PARM FIC 10 

C/EXEC SQL 
C+ DECLARE A CURSOR FOR 
C+ SELECT DBXFIL, DBXLIB, DBXATR, DBXTYP, DBXTXT 
C+ FROM QADBXREF 
C+ WHERE DBXATR = 'PF' AND DBXLIB = :BIB AND DBXFIL 
C+ LIKE :FIC 
C/END-EXEC 

C/EXEC SQL 
C+ OPEN A 
C/END-EXEC