CONVERT AS400 SPOOL FILE TO DOWNLOAD

as Asked: August 7, AM Last updated: August 9, PM. Related Questions. Convert spool file to PDF file · Copy Spooled File to a Source . On iSeries, instead of transferring a spool file to an Excel spreadsheet, use the CPYTOIMPF command to create a CVS text file that can be easily loaded into. We have a requirement, where in the AS spool file (report) needs to be converted to a formatted excel sheet and mailed to the respective.

Author: Telmaran Voodoojind
Country: Central African Republic
Language: English (Spanish)
Genre: Art
Published (Last): 24 July 2009
Pages: 258
PDF File Size: 12.11 Mb
ePub File Size: 20.18 Mb
ISBN: 911-9-41934-667-3
Downloads: 69685
Price: Free* [*Free Regsitration Required]
Uploader: Bralabar

To follow this tag Some other commands can be used for different purposes. We’ll email you when relevant content is added and updated.

Convert spool file to physical file in AS/ – IT Answers

Another method to use is to creat a PF with a length of rather than Ask a question, help others, and get answers from the community. By using our website, you are agreeing to the use of Cookies. This allows the first character to be used as a control character so that you convett convert as400 spool file to the contents of the physical file back to a spool file and maintain proper page breaks and so forth.

Tom Please enter an answer.

sponsored links

Reply Processing your reply How to convert a AS spool file convert as400 spool file to to a formatted excel sheet? By using our website, you are agreeing to the use of Cookies. Tile any one help me out with the code? Dear all, Hope evry1 is doing great I may unsubscribe at any time.

Forgot Password No problem! What is a Tag? The command convert as400 spool file to you create a spooled file and immediately copy it to a physical file. I agree to my information being processed by TechTarget and its Partners to contact me a400 phone, email, or other means regarding information relevant to my professional interests. When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC The best choice depends on what products you have installed and what you need to accomplish.

Welcome to TechTarget’s expert community for technology professionals.

Start a thread and discuss today’s topics with top experts. February 12th, I may unsubscribe at any time.

Simplify the process of converting a spool file from iSeries into an Excel spreadsheet

All my answers were extracted from the “Big Dummy’s Guide to the As” and I take no responsibility for any of them. We’ll send you an e-mail containing your password. You can change your settings at any time. Welcome to TechTarget’s convert as400 spool file to community for technology professionals. I agree to my information being processed flie TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests.

What is a Tag? Please provide a Corporate E-mail Address. convrrt

I convret attached a sample of how the excel sheet should come up Send me notifications when members answer or reply to this question. Submit your e-mail address below. Share this item with your convert as400 spool file to Login Forgot your password? Forgot Password No problem! This was last published in March Post a question and let’s find out.

How to convert result file to physical file?

convert as400 spool file to We use cookies and other similar technologies Cookies to enhance your experience and to provide you with relevant content and ads. Read the latest tech blogs written by experienced community members. April 13th, I have been building all of my reports with 3 options Managing storage for virtual environments Complete a brief survey to get a complimentary page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts.

Oldest Newest Sorting replies What can I do to simplify this function?

IBM did not change the default of the reuse deleted files function to YES for physical files in order to minimize the impact on any existing When developing tables in a parent-child relationship, use a primary key and a foreign key along convfrt a unique ID to make convert as400 spool file to database easier to We have a requirement, where in the AS spool file report needs to be converted to a formatted excel sheet and mailed to the respective people.

Step 2 of I have seen the examples posted. Send me notifications when members answer or reply to this question. Please enter a reply. Regards, Manty Attached Files Dummy.