Antwort: select statement volume status

2002-10-14 Thread Sascha Braeuning
Hello, use the following: select volume_name,stgpool_name,pct_reclaim,status,access from volumes where access='READONLY' For access you can set: READONLY, READWRITE, UNAVAILABLE, DESTROYED MfG/regards Sascha Bräuning Sparkassen Informatik, Fellbach OrgEinheit: 6322 Wilhelm-Pfitzer Str. 1 70

Re: select statement volume status

2002-10-14 Thread Vazquez Vegas, Sergio
statement volume status hi all, i need a select statement, which output shows the status of the volumes like unavailable, read only and so on. thanx for help. regards joe Joerg Heiken Operator BBDO Interactive GmbH Gruenstr. 15 D-40212 Duesseldorf phone: +49-211-93 08-403 fax: +49-211-93 08-360

Re: select statement volume status

2002-10-14 Thread Raghu S
select volume_name,access from volumes Joerg Heiken@BBDO_ITo: [EMAIL PROTECTED] NTERACTIVE cc: Sent by: Subject: select statement volume status Joerg

Re: select statement volume status

2002-10-14 Thread Robert Ouzen
ECTED]] Sent: Monday, October 14, 2002 11:03 AM To: [EMAIL PROTECTED] Subject: select statement volume status hi all, i need a select statement, which output shows the status of the volumes like unavailable, read only and so on. thanx for help. regards joe Joerg Heiken Operator BBDO Interacti

select statement volume status

2002-10-14 Thread Joerg Heiken
hi all, i need a select statement, which output shows the status of the volumes like unavailable, read only and so on. thanx for help. regards joe Joerg Heiken Operator BBDO Interactive GmbH Gruenstr. 15 D-40212 Duesseldorf phone: +49-211-93 08-403 fax: +49-211-93 08-360 mailto:[EMAIL PR