Q

How to import an iSeries file

One Search400.com user writes, "How can I import a file that is sitting in a network server into an iSeries using FTP? Is it possible that it can be automated within the iSeries?" Thankfully, PC/Windows connectivity expert Shahar Mor was on hand with some advice.

How can I import a file that is sitting in a network server into an iSeries using FTP? Is it possible that it can be automated within the iSeries?
I assume the file on the server is text file with fixed format. What can be done is this:

-- Enable QNTC. This is a way to map NT drive to the iSeries so that the network file is known to the iSeries as /qntc/servername/drivename/directoryname/filename. You can read more on QNTC here.

-- Copy the text file to the database file using CPYFRMIMPF, as described, here .

This was first published in December 2005

Dig deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close