Thank you Herfried, this is a start

Cheers

> ----------
> From:         Herfried Abel[SMTP:ha7 AT DAIMLERCHRYSLER DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         14 February 2000 15:01
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: SQL the ACT log
>
> 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
> 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
> >
>