Re: SQL into RPG

["Mihai CARSTOIU" <tzighi@xxxxxxxxx>]

Hi,
If STRING does not look like '%ABCABC%' then you probably will get the count
= 0.
For LIKE operations do fill in the variable the % as needed.

Hope it helps
mihai

http://rpgCRUD.ro



On 12/12/07, GUY_HENZA@xxxxxxxxxxxxxx <GUY_HENZA@xxxxxxxxxxxxxx> wrote:
> C/Exec SQL
> C+ SELECT COUNT(*) INTO :NRECS FROM FILE
> C+ WHERE DATA LIKE :STRING
> C/End-Exec
>
> Regards,
>
> Guy
>
>
>
>
>                       pepitovadecurt
>                       <pepitovadecurt@gm        To:
> rpg400-l@xxxxxxxxxxxx
>                       ail.com>                  cc:
>                       Sent by:                  Subject:  SQL into RPG
>                       rpg400-l-bounces@m
>                       idrange.com
>
>
>                       12/12/2007 07:59
>                       AM
>                       Please respond to
>                       RPG programming on
>                       the AS400 /
>                       iSeries
>
>
>
>
>
>
> How I can and control an SQL sentence from a RPG program?
>
> --
> 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.
>
>
>
>
>
> --
> 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.