×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Any reason you are favoring this over something like:
:parmSnapShPath = ' ' and :parmSnapShPath like '%' || trim(Class.snapshot) || '%'
The only real issue I would have with this is that using a user variable like Class.snapshot could leave you vulnerable to SQL injection.
Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx
-----rpg400-l-bounces@xxxxxxxxxxxx wrote: -----
To: rpg400-l@xxxxxxxxxxxx
From: Naveen Kapoor
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
Date: 06/22/2012 11:23AM
Subject: Like statement within case statement
Hello,
Case
When :parmSnapShPath <> ' '
Then
:parmSnapShPath like '%' || trim(Class.snapshotpath) || '%'
Else
class.snapshotpath = class.snapshotpath
End
For some reason it is not liking the like statement within the case
statement, is this a limitation? if yes is there is any solution for this.
Thanks in advance!
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
