Unfortunately the select syntax is not quite as concise when it comes to
multiple matches:

Off the top of my head, try something like:

select volume_name from contents where filespace_name='/usr/local' and
hl_name='lib/emacs/etc' and (ll_name='COPYING' or ll_name like('README%'))

which looks for /usr/local/lib/emacs/etc/COPYING or
/usr/local/lib/emacs/etc/README* in shell wildcard syntax
(/usr/local/lib/emacs/etc/README.* in regular expression syntax).

I think.  Remember, it is 6:52am and I haven't had any coffee today...

Cheers...
Bruce

"Pemberton, Steven" wrote:

> Guru's,
>
> In our continued effort to use ADSM in a cruel and unusual manner we need to
> determine which tapes contain a set of files.
>
> So far our best effort involves using a shell script to query volumes in the
> stgpool, query contents of these volumes, and grep for file_name.
>
> This seems to work, but I'm sure there must be a nicer way - perhaps via the
> SQL interface. So far though my SQL attempts seem remarkably slow to
> execute.
>
> Does anyone have a nice *fast* SQL query to determine which tapes contain a
> certain set of files?
>
> Thanks,
> Steven P.

--
Bruce Elrick, Ph.D.
Bruce Elrick, Ph.D.
mailto:belrick AT home DOT com
http://members.home.net/belrick/