View previous topic :: View next topic
|
Author |
Message |
vijaysankar
New User
Joined: 27 Feb 2008 Posts: 9 Location: chennai
|
|
|
|
Can any one inform me , where I can find the detail for how to send mail through JCL with excel attachment |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Before that I wonder How you created valid XLS which you are trying to attach? |
|
Back to top |
|
|
vijaysankar
New User
Joined: 27 Feb 2008 Posts: 9 Location: chennai
|
|
|
|
right now I am able to send the PS file in .TXT format. I saw some discussion in this forums, they are able to send mail with .xls as attachment. |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
vijaysankar wrote: |
right now I am able to send the PS file in .TXT format. I saw some discussion in this forums, they are able to send mail with .xls as attachment. |
so it's not the business requirement.
anyways, post the thread which you are referring to and what you want to understand... |
|
Back to top |
|
|
vijaysankar
New User
Joined: 27 Feb 2008 Posts: 9 Location: chennai
|
|
|
|
..i missout the link...that why i posted here to know how to code JCL for my requirement. My PS file contains report of my testing. every time when I ran my JCL I will receive an mail with .TXT as attachment, then I use to change the text file into EXCEL sheet format. Instead of changing every time, it will be better if i receive the mail in excel sheet format.
My code is
//SYSTSIN DD *
EXECUTIL SEARCHDD(YES)
ISPSTART CMD(EOCPNOTE)
/*
//MSGFILE DD *
-SUB RULE DETAIL'S
-START MESSAGE -
/*
// DD DISP=SHR,DSN=TENV.RPACK.TOOLS.ZZ.JCL(MAILV)
// DD *
-ATT- DSN TENV.LLU50.TOOL.OUTPUT.REPORT
/*
// DD *
-MSG-
-MSG- |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
Excel is a Microsoft standard and there are documents on the Internet that will give you all the specifications you need to create a .xls file on the mainframe to send to a PC. However, the last time I looked I estimated probably 1000 to 2000 hours of effort to design, implement, and test such a solution because the Excel format specifications are hundreds of pages.
Another option is to convince your organization to spends the tens (or hundreds) of thousands of dollars required to purchase a product that does such conversions.
The cheapest, easiest option is to give up on the idea of generating Excel files on the mainframe, create .csv (comma delimited) files and transfer them. Excel quite happily reads .csv files and they are pretty easy to create -- much easier than .xls files. |
|
Back to top |
|
|
donateeye Warnings : 2 New User
Joined: 01 Jun 2007 Posts: 62 Location: chennai
|
|
|
|
As Robert said, you can use the tect file, .csv format. Infact you dont have to create one... whatever you have in excel, just do a Save As to have it in txt or csv format and then xmit it. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
whatever you have in excel, just do a Save As to have it in txt or csv format and then xmit it. |
Before posting "just anything" you need to read the request and provide an answer that has something to do with the question/requirement.
Why do you suggest saving from Excel when the task is to create a mainframe file to be read into Excel. . .
And improperly quoting someone else gives false info. . . Robert said nothing like what you posted. |
|
Back to top |
|
|
|