[004] IBM i (AS/400): Import CSV file into physical file

Показать описание

In this video we use the CPYFRMIMPF (copy from import file) command to load data from a CSV file into a physical file (database table) we created in the last video. We'll see how error rows are handled, as well as options we have for dealing with NULL values.

Mainframes & More with Matthew

Рекомендации по теме

Комментарии

Fearless teacher!
Very nice video explaining CSV import!
Thank you!

higiniofuentes

Thanks again for the nice video. I should be able to create my own databases from the different tables I used in courses before.

Stosszahlansatz

You can see the error messages by moving the cursor on the ..x number of records copied ...status message, then press F1 then F10. A list of errors will be displayed and you can press F1 on each message.

roadgeek

Thank you for this very interesting video!
Have you a video to do the way round (export from DB2 to CSV)?
Or you can explain how to do it?
Thank you!

higiniofuentes

thank you for your video! so, can i use the windows command prompt the same way, you are using it, to ftp?

alkisko

Thanks for your helpful guide.

But I'm facing some problems related to "file encoding".

I should import data from a vendor CSV file encoded in UTF-8 BOM format.

I tried to use command parameter TOCCSID trying some corresponding values with no success.

I mean, the result is that the command writes all the CSV data on the physical file, I correctly managed every import feature on the command but not CCSID.

When I try to use the data written on the physical file (also a simple SQL select), the data are displayed as "corrupted".

In fact in the UTF-8 BOM encoding standard, the file has a starting hidden value that specifies the file encoding that is wrongly managed by the CPYFRMIMPF command and corrupt all the datas... this special character looks like ï»¿ checking the csv file content from QSHELL - CAT command and also at the beginning of each row there is a special character that the system can't decode and that I can see using an external SQL client ...

Do you have any suggestions?

Filippo

I have to do the same thing by FTP, need to import a CSV file through cl programming any help.

shashankrai

Hi Mentor ..

Can we create text file whatever we are seeing on green screen for our reading purpose?

ersushildubey

[004] IBM i (AS/400): Import CSV file into physical file

[004] IBM i (AS/400): Import CSV file into physical file

ExcelIt-Import excel to IBM i and export IBM i to excel (AS/400,iSeries)

Import CSV file into PF in IBM i AS400

IBMi (AS400) - Download data from IBMi to spreadsheet | as400 tutorial for beginners in English |

Download and Upload data between IBM i and PC | Data Transfer and Database files having CCSID 65535

2019 7 31 IBM i 7 4 Overview

IBMi (AS400) - data transfer from excel to ibmi l | access client solutions | ibm i access client |

Automate IBM i Data Import from multiple formats and sources

data transfer from ibm i to excel | access client solutions | ibm i access client solutions tutorial

IBM AS400 Application System 400 recycling #as400 #ibms400

IBM i Series or AS/400 integration with Saviynt using IdentityForge connector

data transfer from excel to ibmi l | access client solutions | ibm i access client solution tutorial

Copy From Import File CPYFRMIMPF to copy data from import or stream file to the PF in IBM i (AS400)

[003] IBM i (AS/400): Create database table with DDS

AS 400 tutorial for Beginners | Lesson 4 | First RPGLE Hello World Program.

IBM iSeries (AS/400) Group Jobs demo video

Copy To Import File CPYTOIMPF to copy an externally described file to an import file or stream file

IBM iSeries\Excel Interface Video 2 of 2: Key to AS/400 Terminal

10 Buoni Motivi per IBM ACS - 04 Data Transfer

IBM AS400 I-Series Server

Test Automation for Mainframe (IBMi AS/400)

Downloading IBM i library or objects using FTP in IBM i (AS400)

iSeries Data to Excel Webcast

[005] IBM i (AS/400): Querying data with Query for IBM i and DB2 for IBM i