Add password to attachment in mainframe.

Other Mainframe related questions which attracts you and there is no suitable Forum you find for it and related FAQs.

Topic author
Neeraj N
Registered Member
Posts: 34
Joined: Tue Aug 20, 2013 12:49 pm
Has thanked: 2 times

Add password to attachment in mainframe.

Postby Neeraj N » Sat Feb 11, 2017 7:27 am

Hi All ,

I need to send a mainframe report as an attachment in the email which I'm able to do but this report is opend as excel sheet which should be password protected excel sheet. Can we set the password of the excel in mainframes itself some way?



Online
User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1275
Joined: Fri Jun 28, 2013 1:22 am
Location: East Dubuque Illinois
Has thanked: 2 times
Been thanked: 90 times

Re: Add password to attachment in mainframe.

Postby Robert Sample » Sat Feb 11, 2017 9:19 am

How are you sending the data from the mainframe? If you are using a package that creates the Excel spreadsheet on the mainframe and transmits it, maybe. If you are sending comma-delimited data through SMTP, then the answer is definitely not.




Topic author
Neeraj N
Registered Member
Posts: 34
Joined: Tue Aug 20, 2013 12:49 pm
Has thanked: 2 times

Re: Add password to attachment in mainframe.

Postby Neeraj N » Wed Feb 15, 2017 2:33 pm

I'm sending attachement using IEBGENER as comma-delimited file. So as per your asnser, I need to ask the front end to add the password in the excel?



Online
User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1275
Joined: Fri Jun 28, 2013 1:22 am
Location: East Dubuque Illinois
Has thanked: 2 times
Been thanked: 90 times

Re: Add password to attachment in mainframe.

Postby Robert Sample » Wed Feb 15, 2017 5:34 pm

A comma-delimited file CANNOT, under any circumstances, have a password protecting it -- it is a text file, period. Once the file is on a PC and converted into Excel, you can THEN add a password to the Excel spreadsheet. However, until the data is transmitted and converted into Excel, a password is not possible.

What is the purpose of the password? If it is to protect the data going from the mainframe to the server (or PC), then the solution is to use a secured transfer (such as SFTP, FTPS, or other product), not attempt to put a password on a comma-delimited file. If the purpose is to protect the data once it is in Excel, then put the password on before saving the Excel data.




Topic author
Neeraj N
Registered Member
Posts: 34
Joined: Tue Aug 20, 2013 12:49 pm
Has thanked: 2 times

Re: Add password to attachment in mainframe.

Postby Neeraj N » Fri May 05, 2017 10:58 pm

Robert Sample wrote:Source of the post A comma-delimited file CANNOT, under any circumstances, have a password protecting it -- it is a text file, period. Once the file is on a PC and converted into Excel, you can THEN add a password to the Excel spreadsheet. However, until the data is transmitted and converted into Excel, a password is not possible.

What is the purpose of the password? If it is to protect the data going from the mainframe to the server (or PC), then the solution is to use a secured transfer (such as SFTP, FTPS, or other product), not attempt to put a password on a comma-delimited file. If the purpose is to protect the data once it is in Excel, then put the password on before saving the Excel data.

Thanks Robert. We had opted for the first solution you have suggested above.

Was just thinking why can't notepads have password?



Online
User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1275
Joined: Fri Jun 28, 2013 1:22 am
Location: East Dubuque Illinois
Has thanked: 2 times
Been thanked: 90 times

Re: Add password to attachment in mainframe.

Postby Robert Sample » Fri May 05, 2017 11:42 pm

Because a password requires a mechanism to read the file and use the password to decrypt the file. Notepad simply reads the data from the file and puts it upon the screen -- so there is no mechanism to allow a password to be used.




Return to “Other Mainframe Topics, Off-Topics, FAQs.”

Who is online

Users browsing this forum: No registered users and 2 guests