ADSM-L

Re: Help on Select command

2003-01-30 03:38:14
Subject: Re: Help on Select command
From: Æbelø Kaj-Flemming <KAE AT DANFOSS DOT DK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 30 Jan 2003 09:22:29 +0100
Hi Robert

You can use

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


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

<Prev in Thread] Current Thread [Next in Thread>