ADSM-L

Select ??????????

2000-09-27 03:36:13
Subject: Select ??????????
From: Alessio Prodon <aprodon AT CENTROGESTIONE.G-NET DOT IT>
Date: Wed, 27 Sep 2000 09:34:57 +0200
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          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
<Prev in Thread] Current Thread [Next in Thread>