That is certainly valid, but I find it less cumbersome to type

   q con 064954

rather than

   select * from contents where volume_name='064954'

Also, the QUERY command will perform better than the SELECT, unless there
is some specific reason to use SELECT instead of QUERY.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 12/10/2004
07:36:35:

> maybe it's easier to use:
>
> select [xxx] from contents or
> select [xxx] from contents where tape='[xxx]'
>
> Christian Demnitz
> mailto:christian.demnitz AT sinius DOT com