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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
