IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Creating a file to use in excel


IBM Mainframe Forums -> PC Guides & IT News
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
HappySrinu

Active User


Joined: 22 Jan 2008
Posts: 194
Location: India

PostPosted: Mon Dec 15, 2008 5:10 pm
Reply with quote

Hai,
Could you help me the procedure to drop email with an excel format.

Thanks,
Srini
Back to top
View user's profile Send private message
kothai

New User


Joined: 01 Sep 2008
Posts: 32
Location: chennaii

PostPosted: Tue Dec 16, 2008 8:47 am
Reply with quote

HappySrinu,

Try following code.
Code:
//SENDMAIL JOB (XXX,YYY),                                           
//             'MAIL FILE ',                                           
//             MSGCLASS=X,                                             
//             CLASS=S                                                                           
//*                                                                     
//STEP01   EXEC PGM=IEBGENER                                           
//SYSIN    DD  DUMMY                                                   
//SYSPRINT DD  SYSOUT=*                                                 
//SYSUT2   DD  SYSOUT=(R,SMTP)                                         
//SYSUT1   DD  DISP=SHR,                                               
//                  DSN=DEV.XXXX.TEST.FILE,DISP=SHR
//                  DSN=DEV.XXXX.TEST. EMAIL.FILE


Contents of the file DEV.XXXX.TEST.FILE :
Code:
helo JOBTRAC
MAIL FROM:<HappySrinu@gmail.com>
rcpt to:<HappySrinu@gmail.com>
data
FROM: xxxxx
TO: HappySrinu@gmail.com
SUBJECT: test mail
Mime-Version: 1.0
Content-Type: text/plain; name="ABC.csv"
Content-Disposition: attachment; filename="ABC.csv"

DEV.XXXX.TEST. EMAIL.FILE is the file which should be send as attachment. the extension csv gives the Excel format.
Both files DCB’s should match.

This is the control file DEV.XXXX.TEST.FILE.

Create the control file & the file which needs to be sent with same LRECL, etc. only then it works...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> PC Guides & IT News

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top