Oups ! Once again:



select * from libvolumes where library_name='SCALAR' and status='Private'
and last_use IS NULL



Kaj

-----Original Message-----
From: Robert Ouzen [mailto:rouzen AT UNIV.HAIFA.AC DOT IL]
Sent: 30. januar 2003 08:54
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Help on Select command

Hi to all

I try to figure the correct select syntax to get the volumes from a library
where the status is Private and the last use is empty:

I run:

select * from libvolumes where library_name='SCALAR' and status='Private'
and last_use=' '

and got: ANR2034E SELECT: No match found using this criteria.

But in fact I had some volumes ....

Any help will be appreciate.
Regards Robert Ouzen
E-mail:rouzen AT univ.haifa.ac DOT il