Re: Sending a user results of a query

[vhamberg@xxxxxxxxx]

If you use STRQMQRY to run this, it'll create "sets" of
spooled output until the width is covered. E.g., 300
characters may turn out to be 4 sets at 80 characters
wide. You just have to say only use QRYDFN - one of the
latter parms. And you can say to use the QRYDFN for the
QMFORM, as well.

Might be some gotchas with summary functions.

As to CSV, you can attach a DTAQ to an OUTQ, then wait
on the DTAQ. When one of these comes through, do a
CPYSPLF in the waiting program, then a CPYTOIMPF to get
the CSV. PRTF can be up to 378 wide - make your PF wide
enough.
> I am looking for ideas here. On our system we want a couple remote users to
> run a query. We don't want them to be able to change it, but be able to run
> and have it print. The problem... it is over 300 characters wide :-(. The
> other thing, not as big of a problem, is we have to allow them to run it
> through Lawson, not the green screen. I can do this if it is done through a
> simple call.
>
> One solution I thought of was to send a CSV file. But I don't know how the
> system can automatically create one, and how do they get the file? I could
> email it. But I don't know how to do that either.
>
> Mike Wills
> IT Corporate Support
> Taylor Corporation
> mnwills@taylorcorp.com
> Phone: (507) 386-3187