what i'd do : select the volume names, then for each one call dsmcadm move
data command on it

step 1 :

dsmadmc -id=adminname -pass=adminpass -outfile "select 'EYECATCHER',
volume_name from volumes where-condition..."

will output something like :

eyecatcher VOLUME_NAME
---------- ------------------
EYECATCHER A40004
EYECATCHER A40004
EYECATCHER A40012
EYECATCHER A40015
...

(note : EYECATCHER helps you picking up only meaningful lines)



step 2 :

grep '^EYECATCHER' 

outputs :

EYECATCHER A40004
EYECATCHER A40012
EYECATCHER A40015
...


step 3 :

cut -b 12-

outputs :

A40004
A40012
A40015
...



this gives all in one :

for volume in $(dsmadmc -id=adminname -pass=adminpass -outfile "select
'EYECATCHER', volume_name from volumes where-condition..." | grep
'^EYECATCHER' | cut -b 12-) ; do dsmadmc -id=adminname -pass=adminpass
-outfile "move data ${volume} otheroptions..." ; done
ain't it great ;-) ?
ain't it great ;-) ?





A 14:31 24/01/2001 -0500, vous avez écrit :
>Group
>
>I have created a script name VOLUME_PCT with the following results:
>
>ANR1461I RUN: Executing command script VOLUME_PCT.
>ANR1466I RUN: Command script VOLUME_PCT, Line 5 : select volume_name,
stgpool_name,pct_utilized from volumes
>where upper(stgpool_name)='LNTAPECO' and pct_utilized <50 or
upper(stgpool_name)='LNTAPENO' and pct_utilized <50
> or upper(stgpool_name)='UNTAPECO' and pct_utilized <50 or
upper(stgpool_name)='UNTAPENO' and pct_utilized <50
> or upper(stgpool_name)='NTTAPECO' and pct_utilized <50 or
upper(stgpool_name)='NTTAPENO' and pct_utilized <50.
>
>VOLUME_NAME            STGPOOL_NAME           PCT_UTILIZED
>------------------     ------------------                   ------------
>A40004                 NTTAPECO                                8.1
>A40012                 UNTAPENO                                2.0
>A40015                 NTTAPENO                               48.0
>A40021                 NTTAPENO                              32.9
>A40081                 NTTAPECO                               47.4
>A40156                 NTTAPECO                              15.4
>
>ANR1494I RUN: Command return code is 0.
>ANR1487I RUN: Command return code is RC_OK (OK).
>ANR1462I RUN: Command script VOLUME_PCT completed successfully
>
>My question is how can I generated MOVE DATA commands using the
VOLUME_NAMEs in the results of the above SCRIPT
>
>Thanks
>
>Joe Marchesani .
>
>
                        - * - * - * - * - * - * -
Mes idees n'engagent que moi (vieux proverbe du Net)

Thierry ITTY
eMail : Thierry.Itty AT Besancon DOT org               FRANCE