How to send an Excel format to user via IKJEFT1B



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

How to send an Excel format to user via IKJEFT1B

Postby w91803 » Wed Apr 21, 2010 4:57 am

I used to email a CSV file only. Is there any way that I can email an Excel file to user? If you know, please let me know how. Thank you for help.

Here is my JCL for an example:


//STEP100 EXEC PGM=IKJEFT1B
//SYSEXEC DD DSN=SYS1.USER.REXX,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
%XMITIP XXXXXXX@yyyy.com -
FROM XXXXXXXXX@yyyy.com -
FILE 'doc.CSV' -
w91803
 
Posts: 1
Joined: Wed Apr 21, 2010 4:49 am
Has thanked: 0 time
Been thanked: 0 time

Re: How to send an Excel format to user via IKJEFT1B

Postby Robert Sample » Wed Apr 21, 2010 5:43 am

If the CSV file is not good enough, as I see it you have two choices:

1. Do a market survey of data conversion vendors, find the ones that offer Excel conversion as part of their services (you may find one or more if you are lucky). If you are real, real lucky your site can purchase the product for under 100,000 U.S. dollars (depending upon the machine size, of course). Then get the training on the product and use it. I have never had this need so I've never done a market survey for data conversion products.

2. Create your own mainframe version of the Excel file format and transfer it to the PC. There is a 250-page document from Open Office on Excel file formats through Excel 2003, or you can go with the Microsoft 349-page document that includes Excel 2007. In either case, you will probably spend the better part of a year or two in doing the file formatting and testing.

CSV is simple, easy to transfer, and widely accepted. You would be better off not attempting to do a very difficult (or expensive) replacement that would not gain you much, if anything.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: How to send an Excel format to user via IKJEFT1B

Postby dick scherrer » Wed Apr 21, 2010 6:54 am

Hello and welcome to the forum,

Is there any way that I can email an Excel file to user?
Where is the "Excel" file created originally? Does it already exist somewhere? Are you running some mainframe product that allows creating the output in Excel format?

If you have an already formatted file, sending it should not be difficult. If creation on the mainframe is not already in place, suggest you continue using the .csv file.

Why is the .csv format no longer desired? It will open directly in Excel. . . :?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post