Re: Help on Select command
2003-01-30 03:48:29
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
|
|
|