You might try this:
select * from libvolumes where status='Private' and last_use is null
I hope this helps,
Rick Saylor
At 09:34 AM 9/27/00 +0200, you wrote:
>Hello !!!
>
>I'm running ADSM 3.1.2.55 on AIX 4.3.3. I would like a tape's list in private
>status, not associate to the stgpool.
>
>I see you example :
>
>adsm> q libv
>
>Library Name Volume Name Status Last Use
>------------ ----------- ----------------- ---------
>LIB7332 DS0001 Private Data
>LIB7332 DS0003 Private Data
>LIB7332 DS0004 Scratch
>LIB7332 DS0005 Private
>
>I try with select statement :
>
>select * from libvolumes where status='Private' and last_use <> 'Data'
>
>This command doesn't work !!!
>
>Please, let me know how can I solve this problem.
>
>Thank you in advance.
>
>Alessio Prodon
--------------------------------------------------------------------------
Rick Saylor Austin Community College Voice: (512)223-7511
Senior Systems Programmer 5930 Middle Fiskville Rd. Fax: (512)223-7156
Information Services Austin, Texas 78752-4331
