Re: Like string in embedded SQL

[Luis Rodriguez <luisro58@xxxxxxxxx>]

I forgot to include the quotes at both ends (before the first % and after
the second %). Not near a IBM i right now, but it something like double
quotes ('''').

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Jan 17, 2011 at 6:53 PM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

> Alan,
>
> As I see it, what you are searching for is the string '%:InSearchString%'.
> What happens if you change "InSearchString" to include the percentage
> points, as in:
>
> InSearchString = '%' + %trim(InSearchString) + '%' ;
>
> ?
> and then:
>
> Where OUT132 Like(:InSearchString);
>
> HTH,
> Luis Rodriguez
> IBM Certified Systems Expert — eServer i5 iSeries
> --
>
>
>
> On Mon, Jan 17, 2011 at 6:25 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:
>
> > I need to look for a string like 'Access plan not updated' in an embedded
> > SQL statement in an RPG program.
> >
> > If I do the following in STRSQL it works.
> >
> > SELECT count(*) FROM out132 WHERE OUT132
> > Like('%Access plan not updated%')
> >
> > but the following in embedded SQL does not work.
> >
> > Exec Sql Select Count(*)
> >           Into :Count
> >           From QTEMP/OUT132
> >           Where OUT132 Like('%:InSearchString%');
> >
> > When I look at the complied there is no data field being moved in so
> > obviously it is not seeing the ':' in the string.
> >
> > Any ideas how to code this so it sees the search string?
> >
> > I know that one solution would be to use dynamic SQL but would like to
> > ignore that options if I could.
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.