Page 1 of 1
Emailing Excel/Word documents - possible to make read only?
Posted:
Tue Nov 10, 2009 12:30 amby D9988
I use the following code to email a dataset as an Excel document. I kind of doubt it, but I was wondering if there is an option to make the document readonly/protected? So that the contents cannot be edited when opened with Excel.
Thanks, David
//T000010 EXEC PGM=IKJEFT1B,COND=(0,NE)
//SYSEXEC DD DSN=TEST.MISC.CLIST,DISP=SHR
//SYSPRINT DD SYSOUT=(,)
//SYSTSPRT DD SYSOUT=(,)
//EMAILFLE DD DSN=TEST.T.JUNK(+0),
// DISP=SHR
//EMAILMSG DD *
/*
//SYSTSIN DD *
%XMITIP ('TEST'<TEST@TEST.COM>) -
FILEDD EMAILFLE -
FILENAME TEST.XLS -
FORMAT XLS -
MSGDD EMAILMSG -
SUBJECT 'TEST JOB &DATE'
//*
Re: Emailing Excel/Word documents - possible to make read only?
Posted:
Tue Nov 10, 2009 1:52 amby dick scherrer
Hello,
From the mainframe - no way that i'm aware of.
Depending on the configuration and permissions on the target system, it might be possible to download the file into a directory that has only read-only permission for those users. Check with the admins of the remote system to see if this is possible (it is something i did on unix but have not looked into this on Win-based servers).
Re: Emailing Excel/Word documents - possible to make read only?
Posted:
Wed Nov 25, 2009 10:37 amby rajas.abcdefg
will it possible to email any xcel sheet from a directory, irrespective of it is file name...
Re: Emailing Excel/Word documents - possible to make read only?
Posted:
Wed Nov 25, 2009 10:49 amby dick scherrer
Hello,
will it possible to email any xcel sheet from a directory, irrespective of it is file name...
I do not understand what this asks. Typically, "directory" is not a term used with mainframe datasets (unless they are part of USS). Any valid name should be usable.
I believe there is other misunderstanding here as well. Excel spreadsheets are rarely created on a mainframe and nearly never uploaded to a mainframe.
Re: Emailing Excel/Word documents - possible to make read only?
Posted:
Wed Nov 25, 2009 10:54 amby rajas.abcdefg
as a part of work, we need to pick an excel sheet from a window folder and the name of the file will not be consistent, so will be possible to pick the file from that folder irrespective of its name to some of our mainframe datasets
hoe this helps...
Re: Emailing Excel/Word documents - possible to make read only?
Posted:
Wed Nov 25, 2009 11:02 amby dick scherrer
Hello,
Probably not. . . In order to do this, the pc would have to have an ftp service (rather than an ftp client). Most organizations do not permit pd's to be configured as an ftp server. All pc's tend to have an ftp client.
Regardless of how the file gets to the mainframe, it will have to have a valid dataset name. Many/most pc file names are invalid for use on the mainframe (again, unless this is something to do with USS).
You need to talk with your desktop/network support people and learn what options are available to you.