ADSM-L

Re: Anyone have a list of SELECT commands handy.

1999-03-30 17:23:09
Subject: Re: Anyone have a list of SELECT commands handy.
From: "Zopolis, Jim (TechServ)" <JZOPOLIS AT RUSSELL DOT COM>
Date: Tue, 30 Mar 1999 14:23:09 -0800
Try this...

SELECT volume_name FROM volumeusage WHERE
     node_name=UPPER('$1')

Output:
VOLUME_NAME
------------------
037899
037899
037946
037953
037959
037971
037896

This is script I put in the ADSM DB.  Substitute a client node_name for $1.

Jim

> ----------
> From:         Bill Colwell[SMTP:bcolwell AT DRAPER DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Tuesday, March 30, 1999 12:58 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Anyone have a list of SELECT commands handy.
>
> I don't have a list of handy commands.  I suggest becoming familiar
> with whats in the adsm sql database.  Sql databases are self defining,
> if you know the starting point you can explore the whole thing.  For
> adsm, the starting point is --
>
> select * from syscat.tables
>
> The next step would be --
>
> select * from syscat.columns
>
> Pay attention to the remarks column.
>
> --
> --------------------------
> Bill Colwell
> C. S. Draper Lab
> Cambridge, Ma.
> bcolwell AT draper DOT com
> --------------------------
>
> In <30MAR99.16898925.0070.MUSIC AT MUSICA.MCGILL DOT CA>, on 03/30/99
>    at 03:38 PM, "Mark Brown (CC Operations Supervisor)"
> <CCMB AT MUSICA.MCGILL DOT CA> said:
>
> >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
>
<Prev in Thread] Current Thread [Next in Thread>