Midrange News for the IBM i Community


Posted by: Viking
Information Systems
CA
Performance: Write directly to IFS or to a PF and CPYTOIMPF?
has no ratings.
Published: 09 May 2013
Revised: 10 May 2013 - 2351 days ago
Last viewed on: 14 Oct 2019 (5764 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

Performance: Write directly to IFS or to a PF and CPYTOIMPF? Published by: Viking on 09 May 2013 view comments(4)

Hi all,

If my end goal is to create a .csv file on the IFS for users to open in Excel, which way performs better... and RPG program that writes directly to the IFS, or an RPG program that writes to a PF and then does CPYTOIMPF to get the .csv file to the IFS?

I've done it both ways but am just curious which way performs better? This time I'm anticipating writing just a few hundred records monthly, if that makes a difference.

I like writing to the IFS directly from RPG especially when the number of fields/columns will vary, but this time the number of fields/columns will always be the same, so a PF would work.

Thanks.

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS