not sql but shell , maybe thats ok for you :

#!/bin/ksh
#
# sample script : qact.sh
#
dsmadmc -id=yourid -pass=yourpass q actlog begindate=$1 begint=$2 search=$3
or=se


call from cmd line > qact.sh 02/13/2000 09:00 mount


-herfried
"Doherty, John (ANFIS)" <jdohe1 AT ANFIS.CO DOT UK>@VM.MARIST.EDU> on 14.02.2000
"Doherty, John (ANFIS)" <jdohe1 AT ANFIS.CO DOT UK>@VM.MARIST.EDU> on 14.02.2000
15:40:23

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:  SQL the ACT log


HI folks, quick question to all you SQL guru's

If I want to search the activity log for the duration of my migration
process, I can enter the following command:

"Q ACTLOG BEGINDATE=02/13/2000 BEGINTIME=09:00" -
"ENDDATE=02/13/2000 ENDTIME=12:00 SEARCH=C9840PC1 OR=SE"
I can define this as a script file, but can anyone tell me how I can define
the script using variables for the data and time and search message?

Is this possible?

> John Doherty. Tel:   +44   (0)   141 275 7793
>               Fax:  +44   (0)   141 275 9199
>               Email: JDohe1 AT Anfis.co DOT uk
>
>       Technical Specialist, Storage Management L02S
>
> Email communications are not necessarily secure and may be intercepted or
> changed after they are sent.  Abbey National Financial and Investment
> Services  does not accept liability for any such changes. If you wish to
> confirm the origin or content of this communication, please contact the
> sender using an alternative means of communication.  This communication
> does not create or modify any contract.  If you are not the intended
> recipient of this communication you should destroy it without copying,
> disclosing or otherwise using its contents.  Please notify the sender
> immediately of the error.
>
> ABBEY NATIONAL FINANCIAL AND INVESTMENT SERVICES plc
>         Registered Office Abbey National House 287 St Vincent Street
>         Glasgow G2 5NB United Kingdom Registered in Scotland No 159852
>