hello,

      Can anyone tell me why this select statement did not like 'IF' ? what
is the correct syntax? thank you.



tsm: TSMSERVER1>select VOLUME_NAME, pct_utilized, stgpool_name from volumes
where pct_utilized>0 and pct_utilized<10 and devclass_name
='3584' and STGPOOL_NAME='3584TAPEPOOL' if (rc_notfound) goto reclaim20 upd
stg '3584tapepool' rec=10 exit
ANR2905E Unexpected SQL identifier token - 'IF'.

                                       |

..............................V................................
         d STGPOOL_NAME='3584TAPEPOOL' if (rc_notfound) goto reclaim20

ANS8001I Return code 3.



Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860) 862-8164
cell (860) 961-6976


**************************************************************************************************
The information contained in this message may be privileged and confidential and
protected from disclosure. If the reader of this message is not the intended 
recipient, or
an employee or agent responsible for delivering this message to the intended 
recipient,
you are hereby notified that any dissemination, distribution, or copy of this
communication is strictly prohibited. If you have received this communication 
in error,
please notify us immediately by replying to the message and deleting it from 
your
computer.
**************************************************************************************************