ohhh .. is it that easy ... cool ... thanks alot


-----Original Message-----
From: Bos, Karel [mailto:Karel.Bos AT ATOSORIGIN DOT COM]
Sent: 13 July 2004 17:07
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: alias for sql commands


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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Hashim, Shukrie BSP-IMI/211
Sent: dinsdag 13 juli 2004 10:58
To: ADSM-L AT VM.MARIST DOT EDU
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