Hi, Yes, define the SQL statement in a script called CHKSCRATCH and issue RUN CHKSCRATCH from the commandline.
Regards, Karel -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Hashim, Shukrie BSP-IMI/211 Sent: dinsdag 13 juli 2004 10:58 To: [EMAIL PROTECTED] Subject: alias for sql commands Hi there .. is there a feature in TSM where I could type in select count(*) from libvolumes where status='Scratch' and then call this command ... with an alias for example:- chkscratch [ENTER] will call the sql command above Regards Shukrie