View previous topic :: View next topic |
Author |
Message |
valeti_sashi Beginner
Joined: 11 May 2005 Posts: 12 Topics: 7 Location: Chennai, India
|
Posted: Thu Jun 02, 2005 4:06 am Post subject: Help sending an Excel file as email attachment thru Mainfram |
|
|
We are facing a problem in sending excel files through XMITIP.
I tried sending a PS file as excel created by focus code, using XMITIP step. But the JCL gave an error message saying ' |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
sree_sen Beginner
Joined: 24 Jun 2005 Posts: 10 Topics: 3
|
Posted: Fri Jun 24, 2005 9:32 am Post subject: |
|
|
Hi Valeti,
Could you please tell me how did you create the excel file from a PS using FOCUS tool. DO you have any snippet for this?
And also, when you have the PS file why aren't you trying to send the ps file thru jcl instead of the excel format. _________________ -Sree |
|
Back to top |
|
|
Jaya Beginner
Joined: 02 Sep 2005 Posts: 77 Topics: 10 Location: Cincinnati
|
Posted: Tue Aug 08, 2006 3:38 am Post subject: |
|
|
Hi,
I am currently sending an EMAIL with .CSV file as an attachment and it is working fine. The attached CSV file have 7 columns. The first row is the header and the remaining row has detail information. I did like to know whether it is possible to format the attached CSV file.
Say..
1. I wanted to make the first row, the header row as bold and give some colouring to the first row cells if possible..
2. Fix the column width of all the 7 columns from A to G.
Thanks,
Jayaprakash S. _________________ "Great spirits have always encountered violent opposition from mediocre minds."
-Albert Einstein |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
Posted: Tue Aug 08, 2006 5:22 am Post subject: |
|
|
Jaya,
1. I am not sure if you can do it on mainframe
2. Why not create the .csv file with column width it self ?
ex:
Code: |
Emp-id pic x(10).
FirstName pic x(15).
Lastname pic x(15).
Address pic x(30).
|
Code: |
Emp-id pic x(10).
filler pic x(01) value ','.
FirstName pic x(15).
filler pic x(01) value ','.
Lastname pic x(15).
filler pic x(01) value ','.
Address pic x(30).
filler pic x(01) value ','.
|
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
Jaya Beginner
Joined: 02 Sep 2005 Posts: 77 Topics: 10 Location: Cincinnati
|
Posted: Tue Aug 08, 2006 7:11 am Post subject: |
|
|
Kolusu,
Thanks for the reply...
I have generated the comma seperated fixed block file using a code similar to your model code. The data is getting seggregated properly among the columns i.e My detail lines are in sync with their header. But there is no link between the picture clause of the header field , detail field and the column width of (A to G columns) seen while opening the CSV file in the mail attachment. All columns in CSV file have some default column width. To read that CSV file, i have to manually allign the columns by right clicking a selected column and increasing the Column width parameter.
Just thinking of controlling that view by means a mainframe code.
Thanks,
Jaya. _________________ "Great spirits have always encountered violent opposition from mediocre minds."
-Albert Einstein |
|
Back to top |
|
|
|
|