×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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?
Thanks,
Kelly Cookson
Senior Software Engineer II
Dot Foods, Inc.
217-773-4486 ext. 12676
www.dotfoods.com<
http://www.dotfoods.com/>
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/>>
[cid:image002.png@01D10BD3.03D87F20]
--
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>
midrange.com
