>My question is how to cancel a process which take too long ....  I tried:
>
>select process_num  from processes where process='Backup Storage Pool'
>if(rc_ok) goto cancel
>exit
>
>cancel:
>  Here I am stuck !!!!!!!! How can I do a can process from the output I got
>before.

TSM server scripting is primitive, harking back to the early days of TSO Clists.
There is no provision for isolating and passing data.
In my notes at http://people.bu.edu/rbs/ADSM.QuickFacts
I've summarized a technique cited in historical postings:

SELECT, literal column output           You can cause literal text to appear in
                                        every row of a column, which is one way
                                        to generate lines containing commands
                                        which operate on various database
                                        "finds". The form is:
                                         'Cmdname' AS "              " ...
                                        where Cmdname will appear on every line.
                                        For example, here we generate
                                        Update Libvolume commands for scratches:
                                        SELECT 'UPDATE LIBV OUR_LIB' AS -
                                         "                          ", -
                                         VOLUME_NAME, ' STATUS=SCRATCH'  FROM -
                                         LIBVOLUMES WHERE STATUS='Scratch' -
                                         > /tmp/select.output

That is, you can produce an external executable, which you might subsequently
execute as a Macro, or even another script.

  Richard Sims, BU