RE: AS400 Query - Passing info from CL program?

We have numerous date-dependant queries run overnight.  We write the date
range required to a physical file, and link this into the queries.
The advantage of this method is that it's really easy to re-run a particular
date range, just by dfu'ing one file - rather than altering ~20 queries!


Regards,
Stuart
                                     
Stuart Allen
European Systems Analyst
Fellowes

Tel: +44 1302 892273
Fax: +44 1302 890003
mailto:sallen@fellowes.com


> -----Original Message-----
> From: Peter Dow [SMTP:pcdow@yahoo.com]
> Sent: Sunday, November 21, 1999 4:25 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: AS400 Query - Passing info from CL program?
> 
> If the date range is based on the current date, you could calculate it. In
> Query you can define a result field that is the current system date as a
> native date field. You can then add/subtract days, months, years from/to
> it.
> The function is CURRENT(DATE). You can also use CURRENT(TIME),
> CURRENT(TIMESTAMP), etc.
> 
> You can use the DATE() and CHAR() functions to convert a character field
> to
> a date and vice versa, so you can use these to calculate 1st and last day
> of
> a month.
> 
> Or you can use Query Manager queries, which do allow passing parameters.
> 
> HTH
> Peter Dow
> Dow Software Services, Inc.
> 909 425-0194 voice
> 909 425-0196 fax
> 
> 
> ----- Original Message -----
> From: <Forwiw@aol.com>
> To: <midrange-l@midrange.com>
> Sent: Saturday, November 20, 1999 3:55 PM
> Subject: AS400 Query - Passing info from CL program?
> 
> 
> > Anyone,
> >
> >     Is there a way to pass info from a CL program to a Query?
> >
> >     We would like to run a scheduled Query (at night), with
> >     info passed from a CL program (date range) into the Query,
> >     record select,  so that there is no operator intervention.
> >
> >     New at AS400, & CL.
> >
> >     Any info will be greatly appreciated.
> >
> >     Thanks,
> >     Sandi
> >
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> david@midrange.com
> > +---
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Bid and sell for free at http://auctions.yahoo.com
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---