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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: