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

[@higiniofuentes2551]

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

[@JanetAllen-d5t]

absolutely great teacher!

[@ThaRealERAQ]

I am trying to capture the O/S version in a file for an IT audit. Will this command do that? DSPSFWRSC OUTPUT(*OUTFILE) OUTFILE(QTEMP/PROD_INFO) OUTMBR(*FIRST *REPLACE). Thanks

[@roadgeek123]

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.

[@Stosszahlansatz]

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

[@MatthewMainframes]

Glad you're enjoying the videos, René! Isn't it fun learning about different systems?

[@alkisko1260]

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

[@higiniofuentes2551]

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!

[@ThePowerSocket]

Thanks, very useful!

[@ersushildubey7152]

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

[@Filippo579]

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?

[@Filippo579]

Solved! I solved this issue with this parameter RCDDLM(*CRLF) However, thanks for your guide ;)

[@shashankrai8780]

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

[@berrychase6209]

Thank you .

[@joshchamplin5652]

Are you running this in an emulator?

[@MatthewMainframes]

Nope, unfortunately as far as I know there's no emulator that can run IBM i. I have a Power 720 and Power S822 server.

[@kadirdurmaz8932]

He is running a real server and I think he is accesing the server using tn5250j for Mac. However you can use a free public server named PUB400 to try all of his contents if you are looking for. 🙂

[@MatthewMainframes]

@@kadirdurmaz8932 Close -- this was tn5250j running on Linux 🙂