Q
Problem solve Get help with specific problems with your technologies, process and projects.

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 last 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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close