Re: iSphere source search

On 5/19/2015 5:51 AM, Austin, Mark wrote:
> Has anyone successfully used the iSphere source search option to export the results to a member filter?

Yes.  I am using 2.6.0.b008.

> I have just tried and it asks to specify a filter and it doesn’t seem to matter what I put in there it comes back and says could not create filter.

The way I work is rooted in the past.  I create a new connexion for each
project.  Mostly because there wasn't any ability to create a filter
from a search in the past, but I digress.  I manually add each member I
need into a filter within that connexion, so all of the things I touch
are all together in one place.  This isn't an advert for doing things my
way, it's setting up how I tried the search export.

I created a new connexion for generic members.
I then created a member filter for QRPGLESRC.*.
I used iSphere search to find 'contains select' and 'contains into'.
(I'm looking for SQL SELECT zzz INTO :HOST_VARIABLE)
Get back a fair list.  Click on the Export to Member Filter icon on the
iSphere search view.  It looks like a barrel with arrows pointing right.
 The 'Filter' dialogue box pops up.  I type in sql_select_into and click
OK and that filter is very quickly put into my generic connexion - the
same connexion I was in when I did the search.