Re: SQLRPG with LIKE

[Kyle Collie <kcollie@xxxxxxxxx>]

I think you will need to specify a wildcard character when using LIKE.

Kyle


On Wed, 17 Nov 2004 15:17:20 +0100, Damien Spriet
<damien.spriet@xxxxxxxxxxxxxxxxxxxx> wrote:
> 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
> 
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 
>