ADSM-L

Re: Select ??????????

2000-09-27 09:57:52
Subject: Re: Select ??????????
From: Rick Saylor <rsaylor AT AUSTIN.CC.TX DOT US>
Date: Wed, 27 Sep 2000 08:56:46 -0500
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
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
<Prev in Thread] Current Thread [Next in Thread>