Re: Sending a user results of a query

["Rick Rayburn" <the400man@xxxxxxxxxxx>]

Attaching DTAQ to OUTQ? That's great! Can you tell me the parameters to
check for off of the RCVDTAQ command for a spool file coming in?

Also, I have never tried the CPYTOIMPF command...can you tell me a little
about it? Is it only for spool files? Does it automatically create CSV
formatted file? What is it generally used for? Anything you can share will
be of great assistance Vernon.

Thanks for your time as always.

Rick Rayburn


>From: vhamberg@attbi.com
>Reply-To: midrange-l@midrange.com
>To: midrange-l@midrange.com
>Subject: Re: Sending a user results of a query
>Date: Wed, 14 Aug 2002 22:55:50 +0000
>
>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
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com