IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


Report-email



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...
Post a reply

Report-email

Postby kiran_wiproblr » Tue Feb 21, 2012 12:05 am

Hi could some one help me out?

I would like to send reports in XL(Microsoft Excel) format, with out disturbing of alignment which is there in original data set.
Report consists of yesterday’s data.


My expected features in the email

1. Report present in AAA.BBB.CCC data set and it has to send in XL with file name as “Report for yesterdays date”
Ex: “Report for 16 February 2012”

2. My recipients has to receive reports with subject line as “Report for yesterdays date”
Ex:: “Report for 16 February 2012”

3. Email body is there in XXX.YYY.ZZZ data set

4. Email IDs to which the above report has to sent is in MMM.NNN.OOO data set

I have seen some programs which is using XMITIP in my project, but is not exactly match with my requirement

NOTE: XL(Microsoft Excel) has to set with out disturbing of original alignment of original data set.
kiran_wiproblr
 
Posts: 21
Joined: Fri Feb 10, 2012 11:10 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Report-email

Postby enrico-sorichetti » Tue Feb 21, 2012 12:15 am

I would like to send reports in XL(Microsoft Excel) format, with out disturbing of alignment which is there in original data set.

the report will be sent in the format it was produced by Your application
to transform <anything> into EXCEL format will require additional processing steps by EXCEL aware applications.
I have seen some programs which is using XMITIP in my project, but is not exactly match with my requirement

I find hard to believe that XMITIP would not satisfy somebodys requirements, no mail program will transform a <file> into an EXECL datasheet
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3002
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times
Top

Re: Report-email

Postby Akatsukami » Tue Feb 21, 2012 12:20 am

kiran_wiproblr wrote:Hi could some one help me out?

I would like to send reports in XL(Microsoft Excel) format, with out disturbing of alignment which is there in original data set.
Report consists of yesterday’s data.


My expected features in the email

1. Report present in AAA.BBB.CCC data set and it has to send in XL with file name as “Report for yesterdays date”
Ex: “Report for 16 February 2012”

2. My recipients has to receive reports with subject line as “Report for yesterdays date”
Ex:: “Report for 16 February 2012”

3. Email body is there in XXX.YYY.ZZZ data set

4. Email IDs to which the above report has to sent is in MMM.NNN.OOO data set

I have seen some programs which is using XMITIP in my project, but is not exactly match with my requirement

NOTE: XL(Microsoft Excel) has to set with out disturbing of original alignment of original data set.

Software that creates Excel workbooks on mainframes costs many thousands of dollars, and it is unlikely that your shop has it. Moreover, you show -- and have shown in your other threads -- a lamentable lack of understanding as to how anything computerish, whether on mainframes or programmable calculators, works. I strongly recommend that you investigate CSV data sets...if you can read and comprehend technical English.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times
Top

Re: Report-email

Postby kiran_wiproblr » Tue Feb 21, 2012 12:37 am

I having one JCL which is the serving the above purpose, BUT
recipients is NOT receiving data in Microsoft Excel.
All the data is getting copied into first column of Microsoft Excel,
I need each filed of mainframe date set has to a separate column in Microsoft Excel.


Select all
//STEP5    EXEC PGM=IKJEFT1B,DYNAMNBR=25               
//STEPLIB  DD DISP=SHR,DSN=SYS4.XMITIP.V1010.LOAD     
//SYSEXEC  DD DISP=SHR,DSN=SYS4.XMITIP.V1010.EXEC     
//SYSTSPRT DD SYSOUT=*                                 
//ADDRESS  DD  DSN=AA.BB.CC(XXX),       
//             DISP=SHR                               
//MESSAGE  DD  DSN=XX.YY.ZZ(AAA),     
//             DISP=SHR                               
//EXLFORFL DD  DISP=SHR,DSN=XXX.YYY.XY
//SYSPRINT DD  SYSOUT=*                               
//SYSTSPRT DD  SYSOUT=*                               
//SYSUDUMP DD  SYSOUT=*                               
//SYSTSIN  DD  DSN=AB.CD.EF(XYZ),     
//             DISP=SHR                               

contents of
//ADDRESS  DD  DSN=AA.BB.CC(XXX)
TO xxx.yyyy@zz.com

contents of
//MESSAGE  DD  DSN=XX.YY.ZZ(AAA)
body of the email
<HI ALL,   
PFB REPORT>

contents of
//SYSTSIN  DD  DSN=AB.CD.EF(XYZ),
*************** Top of Data ***************
%XMITIP (xxx.yyyy@zz.com)    -       
         filedd (EXLFORFL)                             - 
         MSGDD message                                 - 
         FROM xxx.yyyy@zz.com  -     
         FORMAT ZIP/xmit.csv-                             
         filename (XYZ.zip)  -                     
         Subject 'XYZ REPORT'                     
******************************** Bottom of Data **********

Select all
contents of
//EXLFORFL DD  DISP=SHR,DSN=XXX.YYY.XY
is the report which has to be sent in email through Microsoft Excel formate
kiran_wiproblr
 
Posts: 21
Joined: Fri Feb 10, 2012 11:10 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Report-email

Postby enrico-sorichetti » Tue Feb 21, 2012 12:47 am

what is that You do not understand in my previous reply
the report will be sent in the format it was produced by Your application
to transform <anything> into EXCEL format will require additional processing steps by EXCEL aware applications.

the only inexpensive solution is to transform the MF data in CSV format
and have some macro on he excel side to transform it into a report

even if for <security> and <auditing> compliance most organization prefer to send reports in and uneditable format ( PDFs with the proper flags )
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3002
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times
Top

Re: Report-email

Postby kiran_wiproblr » Tue Feb 21, 2012 8:50 pm

Hi Enrico,

Many thanks for suggestion.

Can you please provide the process of transforming MF data to SCV format and then transfer to MS excel
The process has to be automate, so that submission of job will have to send to email ,MS excel as an attachment.
kiran_wiproblr
 
Posts: 21
Joined: Fri Feb 10, 2012 11:10 pm
Has thanked: 0 time
Been thanked: 0 time
Top

Re: Report-email

Postby BillyBoyo » Tue Feb 21, 2012 9:17 pm

Then spend a lot of money on a package which will give you an Excel file.

Or spend a lot of time writing an application yourself.

Or make it a CSV (all this requires is putting commas (or another delimiter) between your fields, and quotation marks (or another delimiter) around your fileds which can possibly contain the first delimeter.

Deliver the file to the user. The user opens the file (probably double-click will be enough) and they can see the data.

OK, yes, you might want to do more when it arrives to the user. You should, like checking it is the right file, from the right business/data date, that it is a complete file. Get a consultant who knows Excel, just for a couple of weeks. Provide a nice file with which you can do integrity checks. Bingo.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times
Top
Post a reply

Return to JCL

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks