Try: select count(*) from sessions having count(*)<5 if(RC_NOTFOUND) goto notfound exit notfound: do something here... exit
You can even add a WHERE clause to further refine the type of sessions you're looking to 'count'. Bill Boyer DSS, Inc. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Paul Zarnowski Sent: Thursday, November 13, 2003 3:30 PM To: [EMAIL PROTECTED] Subject: Way to do comparison in a TSM script? Is there a way to do a comparison in a TSM script? Specifically, I want to run code conditionally based on how many sessions are active (for example). I don't see an immediately obvious way to do this. Thanks. ..Paul
