Mark,

The select statements are regular SQL statement.
For your purpose you can use the following command:

select  volume_name from volumeusage where
     node_name='NODE_NAME'

you can define the script in our DB and use a variable for the node name:

select  volume_name from volumeusage where
     node_name=UPPER('$1')

--
Regards
Regards

Malkit Hayun , UDI
Storage Products Manager
IBM Certified Specialist-ADSM
Office: 972-3-9233440
Fax:    972-3-9233441
Mobile: 972-52-834575
Email: malkit AT udi.co DOT il


Mark Brown (CC Operations Supervisor) wrote:

> Hello,
>
> I am a newbie when it comes to SELCT commands for querying my MVS os390
> ADSM v3 server. Is there a place where I can download "sample" select
> commands? I have used up the samples in the ADSM manual.
>
> In particular I would like a command that can tell me which tapes a
> nodes files are on WITHOUT mounting a tape.
>
> Thank You,
>   Mark Brown, Operations Supervisor
>   McGill University, Computing Centre
>   Phone (514) 398-2321
>   E-Mail --> ccmb AT musica.mcgill DOT ca
>   Home Page --> http://mbrown.cc.mcgill.ca