Re: AW: Locate vs Like

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

I still don't see how Class.snapshotpath is an SQL column - looks more 
like a qualified data structure subfield - I hope Naveen can help me out 
here.

On 6/26/2012 12:09 AM, Birgitta Hauser wrote:
> Where Locate(trim(Class.snapshotpath), :parmSnapSHPath) > 0
>
> For more information, please download the SQL Reference:
> http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafz.pdf
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
> Auftrag von Naveen Kapoor
> Gesendet: Monday, 25.6 2012 22:38
> An: rpg400-l@xxxxxxxxxxxx
> Betreff: Locate vs Like
>
> Hello All,
>
> I have a situation where i have to passin a parameter from a program and in
> the called program I have to use it with IN predicate.
>
> I read that its not possible so tried it with like statement, but I wanted
> to do with LOCATE keyword, do any one have any idea on how to do this.
>
> (Case
> When :parmSnapShPath <>' '
> then :parmSnapShPath
> else '%' || trim(Class.snapshotpath) || '%'
> end ) like '%' || trim(Class.snapshotpath) || '%'
>
> Where parmSnapSHPath is having more than one values like
> ('A','B','C'......)
>
> --
> Regards
> Naveen
> --
> This is the RPG programming on the IBM i / System i (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.