RE: AS400 Query - Passing info from CL program?

[Chris Bipes <rpg@xxxxxxxxxxxxxxx>]

Sandi,

One trick we do here is to use opnqryf in the cl.  We select and sort the
data then cpyfrmqryf to qtemp creating the file.  Then run query pointing
the query to the qtemp version of the file.  You can remove the sort and
selects from the query.  I have found that it is simple and strait forward
and does not use much more resources than selecting and sorting the data
within the query.

Good luck

Christopher K. Bipes     mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst   mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.         http://www.cross-check.com
6119 State Farm Drive    Phone: 707 586-0551 x 1102
Rohnert Park CA  94928 Fax: 707 586-1884

*Note to Recruiters
Neither I, nor anyone that I know of, is interested in any new and/or
exciting positions. Please do not contact me.

-----Original Message-----
From: Forwiw@aol.com [mailto:Forwiw@aol.com]
Sent: Saturday, November 20, 1999 4:56 PM
To: midrange-l@midrange.com
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
+---