Any positive resolutions???? Posted: Sat Jan 31, am. I have tried the above approach and the report is appearing in the body of the e-mail not as an attachment. Also, this only works if the dataset to be sent is 80 bytes, if it is as any report I get a JCL error. Hi, Quote:.
Use Preview see how your post will appear to the forum and when you are satisfied, Submit. Please do not attach screenshots. I've got someone at work that uses this format to send byte records. This works fine in production every day for us. Posted: Mon Feb 02, pm. The jcl submitted is: Code:. Where's all of the MIME protocol code?
There looks to be a lot missing, unless it's included in one of the concatenated datasets. Posted: Wed Jun 10, am.
MIME protocol code??? Please provide sample. Posted: Sat Jun 13, pm. This document gives you the exact specifications for Internet emails and the different options there of. Google can help you find it. How do you know the mail has not been sent? Since you obfuscated the precise email address, I recommend you contact your site support group and have them check the SMTP job output to see if your email did, indeed, get sent.
Posted: Tue Apr 28, am. As I said, you really have to experiment depending upon what you are attempting to do -- and you may have to run a dozen or more tests to get the results you want. Posted: Tue Apr 28, pm. Where are the required Code:.
Does it look like a. The Code:. Also I tried giving the. You should have : Code:. Swathi Muralidharan wrote:. The three datasets need to have the same DCB info. Asked 8 years, 10 months ago. Active 5 years, 9 months ago. Viewed 41k times. Bill Woodger Please add more detail about what you are trying to do. You have tagged your question with "database" but do not mention it in your question. Which database? Where is it running? Do you need to extract from a mainframe dataset to this database and then query it with Microsoft Excel?
Which mainframe operating system are you using? In order to help you we must know more about the problem you are trying to solve. I have a dataset in a mainframe library and I want to ftp that file to Excel. If that can't be done, maybe you could tell, instead, if it is possible to automate a batch file to do ftp connection to mainframe and do a 'GET' to a certain folder.
That's pretty much how you do it. In Windows, you can run FTP from a batch file. Unless you've got some software it costs money which can create an Excel-format file I believe SAS and a couple of other things can do it or unless you are going to take the time to "roll your own" by purchasing a substantial document from Microsoft which tells you how, then a CSV is definitely the way to go. You can create the CSV on the mainframe a program, or your Sort product, for instance then find the standard method that your site uses for transferring files talk to your support people.
Add a comment. Active Oldest Votes. In brief: Create a new blank workbook I'm using Excel Select the first cell in the empty worksheet this step is unnecessary - the cell is already selected - if you've only just created the workbook.
Wait for the data to load. Format the cells. On the Data tab, click Connections , select the connection that Excel created when you specified a URL for the file name , and clear the check box Prompt for file name on refresh. Graham Hannington Graham Hannington 1, 14 14 silver badges 16 16 bronze badges. I'd program the user's access to the data, to ensure that existing data in Excel is backed-up, and then ensure the correct data date, logical filename etc from a header record , — Bill Woodger.
0コメント