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?


Kelly Cookson
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
To: OpenSource@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] [IBMiOSS] CSV file in the IFS, writing it to a DB2 file using Python

Hi all
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.

Mike Loyd
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><http://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,
visit: https://lists.midrange.com/mailman/listinfo/opensource<https://lists.midrange.com/mailman/listinfo/opensource>
or email: OpenSource-request@xxxxxxxxxxxxxxxxxx<mailto:OpenSource-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/opensource<https://archive.midrange.com/opensource>.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com<https://amazon.midrange.com>

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.