My program is creating a delimited flat file on the mainframe. I want to send this file to various users using either IEBGENER or IBMFTP as a CSV file.
My problem is that although the file is sent successfully as a .CSV file but when the user opens the CSV file he finds that for some of the numeric strings which are actually text the leading zeroes get truncated for e.g a string of 01234 will display as 1234 only also the date fields are not getting displayed properly.
I would like to know what control statements should I specify in my control cards so that the data gets displayed correctly. I am showing below a sample control card which sends out the mail in .CSV format:
TO: CC: SUBJECT: Today's report
Please find the report attached.
Any help in this matter will be highly appreciated
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!