I need to take a CSV file in the IFS on the iSeries and write the data to a data base file.
There is a CL command named CPYFRMIMPF. This CL command allows you to import data from a csv file into a DB2 table on the IBMi. You can use this command inside a CL program.
Is there a reason why you would not want to use the CL command to do it?
Senior Software Engineer II
Dot Foods, Inc.
217-773-4486 ext. 12676
From: OpenSource <opensource-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Mike Loyd
Sent: Monday, June 17, 2019 4:04 PM
Subject: [EXTERNAL] [IBMiOSS] CSV file in the IFS, writing it to a DB2 file using Python
This is my first post so here goes.
I am looking at Python to do this. I already have a script to get a XLS spread sheet to a data base file.
I have a simple script to read and print a CSV file. So, I need that piece to parse the CSV file and write the data.
Thanks in advance.
Sr. Software Engineer
Recreational Equipment, Inc. (REI)
' o: 425-278-8265
| * mloyd@xxxxxxx<mailto:mloyd@xxxxxxx<mailto:mloyd@xxxxxxx%3cmailto:mloyd@xxxxxxx>> | www.rei.com<http://www.rei.com
This is the IBMi Open Source Roundtable (OpenSource) mailing list
To post a message email: OpenSource@xxxxxxxxxxxxxxxxxx<mailto:OpenSource@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx<mailto:OpenSource-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.