I’m trying to collect data using an analysis about particular software on Solaris servers. I’d like to ignore case. How would I construct this statement such that it would return results for ibm or IBM, db2 or DB2, etc.
if exists names whose (it contains “IBM” or it contains “international” or it contains “WebSphere” or it contains “rational” or it contains “db2” or it contains “mq”) of pkginfos of pkgdb then names whose (it contains “IBM” or it contains “international” or it contains “WebSphere” or it contains “rational” or it contains “db2” or it contains “mq”) of pkginfos of pkgdb else “None”
I’m trying to avoid having to know the exact case for each string.
if exists names whose (it contains “IBM” or it as lowercase contains “websphere” or it as lowercase contains “rational” or it as lowercase contains “db2” or it as lowercase contains “mq”) of pkginfos of pkgdb then names whose (it contains “IBM” or it as lowercase contains “websphere” or it as lowercase contains “rational” or it as lowercase contains “db2” or it as lowercase contains “mq”) of pkginfos of pkgdb else “None”
This is working as I want it to. However, I’ve been told now that I need to collect version numbers too. Is this possible? If so, how would I do it?
Well, I’m getting closer. This property is returning “The operator “contains” is not defined”. Where am I going wrong?
if exists names whose (it contains “IBM” or it as lowercase contains “websphere” or it as lowercase contains “rational” or it as lowercase contains “db2” or it as lowercase contains “mq”) of pkginfos of pkgdb then (name of it, version of it) of pkginfos whose (it contains “IBM” or it as lowercase contains “websphere” or it as lowercase contains “rational” or it as lowercase contains “db2” or it as lowercase contains “mq”) of pkgdb else “None”