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.
midrange.com
