Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
Chicagoland
How to Convert Database to CSV in RPG IV
has no ratings.
Published: 05 Nov 2013
Revised: 07 Nov 2013 - 1415 days ago
Last viewed on: 22 Sep 2017 (5701 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.

Convertin DB2 Records to CSV on the IFS Published by: Bob Cozzi on 05 Nov 2013 view comments(2)

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

COMMENTS

(Sign in to Post a Comment)
Posted by: clbirk
Premium member *
Comment on: How to Convert Database to CSV in RPG IV
Posted: 3 years 10 months 14 days 21 hours 46 minutes ago

There is another way of doing it and that is with RPG OA which is a free thing for us. Yes you have to write a handler but you can then simply use regular rpg to write out and not have to call special functions. I watched a video on this part of the iprodeveloper (system i network) fall conference and it seemed pretty simple and straight forward.

Of course someone reading this will say there is another way besides what bob outlined and what I said, and that is taking an array and creating the csv line, and writing out the array. (but I think bob's point (and mine) would be, there are some tools that let you do this.

 

Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: How to Convert Database to CSV in RPG IV
Posted: 3 years 10 months 14 days 20 hours 32 minutes ago

I don't think the RPG OA includes anything specific for any type of conversion, specifically there isn't anything for CSV included with it that I've heard of. But yes, you can write code and bury it in functions (as I've done) or in an RPG OA driver. In fact, you could take my examples and bury them in RPG OA and that would work too.