Re: How can I get away from using DFU for data input to Queries?

["Steve Landess" <sjl_123@xxxxxxxxxxx>]

> "Dave Odom" wrote:
> Subject: How can I get away from using DFU for data input to Queries?
>
>
> How can I get away from using DFU as a data input mechanism for queries?
> I'd prefer to use formatted screens/menus and REXX or CL.  I don't want
> to use any RPG unless absolutely necessary as a driver "stub" to display
> screens/menus.  I can do what I ask on other IBM platforms using REXX
> and screens built with XEDIT or the like, but can't seem to find the
> same facility on the iSeries.
>

Dave -

Can you elaborate on what you're trying to accomplish here?  I'm not sure
how you are currently using DFU along with query, unless you're using DFU to
create a record with the necessary data for record selection and then in
your query joining this file with the actual data file that you are
querying.

I take it that you're looking for a way to prompt a user for a variable
value to use when running a Query/400 query so that you can dynamically
select records when running said query.

Is this a correct assumption?

If so, see this FAQ -

(How can I use a variable with Query/400?)
http://faq.midrange.com/data/cache/106.html

You can use DDS to create a display file to use as a prompt screen from
within a CL program, then use the technique described in the FAQ to run the
> query, either interactively or by submitting the command to run in batch.

HTH,
Steve Landess
Austin, Texas
(512) 423-0935