Re: SNDEMAIL: Having problems with a text file

[rob@xxxxxxxxx]

Ok, I am making some headway.  However the archives have alluded to some
magic ptf that will give further options on the CPYTOIMPF command.  I am on
V4R5.  This is the monkeyshines I have to pull now to get this to work.

         CPYTOIMPF  FROMFILE(*LIBL/&FILE) TOSTMF(&IFSFILE) +
                    RCDDLM(*CRLF)

/*
 | Convert the code page into something that SNDEMAIL will
 | handle.
*/
         CHGVAR     VAR(&SENDFILE) VALUE(&DIR +
                      *TCAT '/' *TCAT &FILE *TCAT '_A.TXT')
         DEL        OBJLNK(&SENDFILE)
         MONMSG     MSGID(CPFA0A9) /* Object not found */
         CPY        OBJ(&IFSFILE) TOOBJ(&SENDFILE) +
                      TOCODEPAGE(*PCASCII) DTAFMT(*TEXT)
         DEL        OBJLNK(&IFSFILE)
...
         SNDEMAIL   ADDRESSEE((ROB@DEKKO.COM 'Rob Berendt')) +
                      SENDER(DONOTREPLY@DEKKO.COM 'The AS400') +
                      SUBJECT(&SUBJECT) FILENAME(&SENDFILE) +
                      MESSAGE(&MESSAGE)


Notice the parameters TOCODEPAGE and DTAFMT?  I searched the archives for
CPYTOIMPF and CODEPAGE.  After reviewing the archives I do appreciate what
Roger was doing by creating the file first instead of the additional copy.
What I have is functional.

So is there some magic PTF, or is there a fungus on this apple I am eating?

Thanks to y'all for your help!


Rob Berendt

==================
Remember the Cole!


                                                                                
                                         
                    rob@dekko.com                                               
                                         
                    Sent by:                   To:     MIDRANGE-L@midrange.com  
                                         
                    owner-midrange-l@mi        cc:                              
                                         
                    drange.com                 Subject:     SNDEMAIL: Having 
problems with a text file                   
                                                                                
                                         
                                                                                
                                         
                    02/26/01 09:23 AM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         





I am attempting to use SNDEMAIL to send out a text file and I am having
problems.
I can view the file fine in the IFS with the WRKLNK command.  However when
I send it as an attachment it appears garbled.
Here are my steps:
First I have a physical file with defined fields created as an output file
from Query/400.  It has a CCSID of 37.
Then I use the command:
CPYTOIMPF  FROMFILE(*LIBL/&FILE) TOSTMF(&IFSFfile) RCDDLM(*CRLF)
This created an IFS file with a code page of 37 and a file format of
*TYPE2.
I can view the file fine in the IFS with the WRKLNK command.  I am not
storing it in QDLS; just at the root.  For example '/mmtest3.txt'
Then I use the command:
SNDEMAIL ADDRESSEE((ROB@DEKKO.COM 'Rob Berendt')) SENDER(THEAS400@DEKKO.COM
'Friendly AS400') SUBJECT('This is your requested data.') FILENAME
('/mmtest3.txt') MESSAGE('This text file may be opened in Excel and
manipulated there.')
The attachment is now gibberish.


Rob Berendt

==================
Remember the Cole!

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---