Re: Sending a user results of a query

["Peter Dow" <maillist@xxxxxxxxxxxxxxx>]

Hi Mike,

It sounds like you've already got the query, and that it produces a spool
file, is that correct?  And you'd rather just send the data to the remote
users so they can import it into Excel and print it from there?

If so, change the output of the query to a file, then write a simple CL
program to RUNQRY and CPYTOIMPF. You could email (SNDDST if you have SMTP
set up on your AS400) or batch FTP (see the FAQ) the resulting file.  If
they're not too remote (i.e. they're on your LAN), you could do the
CPYTOIMPF to /QNTC.

hth,
Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 522-3214 cellular
909 793-4480 fax



----- Original Message -----
From: "Wills, Mike N. (TC)" <MNWills@taylorcorp.com>
Sent: Wednesday, August 14, 2002 2:28 PM
Subject: Sending a user results of a query


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