ADSM-L

Re: chained volumes (how to query)

2000-04-28 10:05:48
Subject: Re: chained volumes (how to query)
From: Gary Ison <Gary.Ison AT MAIL.STATE.KY DOT US>
Date: Fri, 28 Apr 2000 10:05:48 -0400
Bruno,

        This is a script for determining if a volume has split files.  You
could probably modify it to do the reverse - find volumes containing a file
by changing the where clause to search by file name.

del scr file-seg
def script file-seg desc='Show segmented file names on a tape volume'
upd script file-seg '/*  -----------------------------------------*/'
upd script file-seg '/*  Script Name: file-seg                    */'
upd script file-seg '/*  Description: Show segmented files on a   */'
upd script file-seg '/*               tape volume.                */'
upd script file-seg '/*  Parameter:   Volume name                 */'
upd script file-seg '/*  Example:  run file-seg n....n            */'
upd script file-seg '/*  -----------------------------------------*/'
upd script file-seg 'select cast (file_name as character(65)) -'
upd script file-seg '         as "                             File  Name
", -'
upd script file-seg '       cast (volume_name as character(6)) -'
upd script file-seg '         as "Volume", -'
upd script file-seg '       cast (segment as character(5)) as "Seg." -'
upd script file-seg '       from contents -'
upd script file-seg "       where volume_name=upper('$1') -"
upd script file-seg "         and segment <> '1/1' -"
upd script file-seg '       order by 1,3,2'
        Gary L. Ison
        Governor's Office for Technology
        101 Cold Harbor Drive
        Frankfort, Ky.   40601
        Phone:  (502) 564-8724
            Fax:  (502) 564-6856
E-mail: Gary.Ison AT mail.state.ky DOT us <mailto:Gary.Ison AT mail.state.ky 
DOT us>

<Prev in Thread] Current Thread [Next in Thread>