select volume_name,access from volumes



                    Joerg
                    Heiken@BBDO_I        To:     ADSM-L AT VM.MARIST DOT EDU
                    NTERACTIVE           cc:
                    Sent by:             Subject:     select statement volume 
status
                    Joerg
                    Heiken@BBDO_I
                    NTERACTIVE


                    10/14/2002
                    02:02 AM
                    Please
                    respond to
                    "ADSM: Dist
                    Stor Manager"





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:j.heiken AT bbdo-interactive DOT de

http://www.bbdo-interactive.de