John -

The formatted nature of Select output and lack of inherent
connectivity to system commands processing thwarts taking that route.
I think the closest you could get that way is via
  select 'cancel process ' as "             ", process_num from
processes' > some_file
which yields like:

                    PROCESS_NUM
---------------     -----------
cancel process              174

One alternative is to take the approach of denying the process what
it needs to continue, as in temporarily rendering the output storage
pool Readonly, until the backup transitions to the next file and
cannot continue. A bit draconian.

The best approach is to have such control externalized via a dsmadmc
mechanism, as programmed into a Perl script, for example.

   Richard Sims

On Jun 30, 2005, at 10:58 AM, John Naylor wrote:

Hi,

I am trying to write  a script that picks up a process number and then
cancels the process/
I cannot get the varable process number into the cancel.
Is this possible?
If it is what do I need to do ?
The script so far is
SELECT PROCESS_NUM FROM PROCESSES -
WHERE UPPER(PROCESS)='BACKUP STORAGE POOL'
IF (OK) GOTO CANPRO
EXIT
CANPRO: CAN PR
EXIT