• Subject: Re: AS400 Query - Passing info from CL program?
  • From: "Peter Dow" <pcdow@xxxxxxxxx>
  • Date: Sat, 20 Nov 1999 20:25:15 -0800

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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].