Cheers guys, I'll look into those posibilities :-)

/Christian




|---------+--------------------------->
|         |           David E Ehresman|
|         |           <deehre01@LOUISV|
|         |           ILLE.EDU>       |
|         |           Sent by: "ADSM: |
|         |           Dist Stor       |
|         |           Manager"        |
|         |           <[email protected]|
|         |           T.EDU>          |
|         |                           |
|         |                           |
|         |           19-12-2002 15:38|
|         |           Please respond  |
|         |           to "ADSM: Dist  |
|         |           Stor Manager"   |
|         |                           |
|---------+--------------------------->
  
>-------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                  |
  |        To:      ADSM-L AT VM.MARIST DOT EDU                                 
                                                         |
  |        cc:                                                                  
                                                  |
  |        Subject: Re: SELECT statement to determine if any drives available   
                                                  |
  
>-------------------------------------------------------------------------------------------------------------------------------|



 select drive_name,drive_state,allocated_to,online from
  drives

>>> csa AT FERROSAN DOT COM 12/19/02 07:34AM >>>
Hi list,

Does anybody know of a SELECT statement that will show if any drives
are
available for use (not in use by another process or session)?

I need this for scripting purposes as I have only two drives in my
library,
and while doing reclamation both drives are in use.


Kind regards,

Christian