RE: Sending a user results of a query

Excellent! But what is the vehicle for automating the sending of the file?
Is it the SNDDST command? If so, do you have any examples of how to utilize
the parameters (there are quite a few!) to:

** e-mail as an attachment
** drop into local lan newtwork or MAIL SERVER?

Thanks again Scott. Any information you share is going to make processing a
lot easier around my client environment.

RR


>From: Scott Mildenberger <Smildenber@Washcorp.com>
>Reply-To: midrange-l@midrange.com
>To: "'midrange-l@midrange.com'" <midrange-l@midrange.com>
>Subject: RE: Sending a user results of a query
>Date: Thu, 15 Aug 2002 09:35:19 -0600
>
>You have it correct.  CSV is what you get if you use the defaults on
>CPYTOIMPF.  CPYTOIMPF will create the file in the IFS, you can then e-mail
>it, copy it, map a drive to it on another server, or whatever you want.  In
>fact, if the users who need access to it are on the local LAN then they
>could map a network drive to the IFS folder and open the file directly.
>
>Scott Mildenberger
>
> > -----Original Message-----
> > From: Rick Rayburn [mailto:the400man@hotmail.com]
> > Sent: Thursday, August 15, 2002 9:10 AM
> > To: midrange-l@midrange.com
> > Subject: RE: Sending a user results of a query
> >
> >
> > this is great Scott!
> > So, let me see if I have some of this straight: I read in the
> > spool file
> > attributes from the dataq, call the clp program
> > (e.g.'MRLMKTD3C') to copy
> > spool file to a, for instance, 132 byte flat PF and then
> > execute a CPYTOINPF
> > command to send a CSV-formatted file (is CSV the default on CPYTOINPF)
> > to...????....mail server?...another 400?...any address on my LAN?...
> >
> > Thanks again Scott. This info is very helpful.
>_______________________________________________
>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