How to upload files from windows 2000 to i-series .

pts.
Tags:
AS/400
I need to upload .csv files to iseries. These files are residing on windows 2000 system. Will appreciate any help with this regard. TIA.

Answer Wiki

Thanks. We'll let you know when a new response is added.

in batch mode ?
then assign a shared NT directory to the 400 :
in the 400, type MD /QNTC/myserver
required : your 400 account+password is a valid NT account+password.
this makes you able to read any data residing on the NT server directly within your CLP with commands CPYFRMSTMF, CPYFRMIMPF, …
remark : if your 400 is in the same domain than the NT server (I don’t know what does that means), the attachment is done by the IPL (it is promised by an IBM doc I have lost).

in interactive mode ?
install iseries client acces, declare the netserver, share an IFS folder : then you can see it with the PC explorer. Just drap and drop your file in the ifs folder.

=======================================================

In short, you copy to the iSeries the same way you would copy to another Win2K system — drag and drop to a shared directory or issue a Windows command to do the copy.

Your iSeries can share directories out to the Windows Network Neighborhood as can Linux systems, Windows systems and others.

Locate an appropriate share or create one. Or put the .CSV files into a shared directory on your Win2K PC and run commands on the iSeries to copy from there. The iSeries can access shares just like your PC can.

Tom

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Avinashjham
    There are the following options: Option 1- Copy the .CSV files to the QDLS or IFS folder on the AS/400. Then either write a RPG/400 program to parse and extract or else use the CPYFRMIMPF command. Option 2- Use the Client Access Data Transfer upload button directly to the database. Option 3- FTP the CSV file into AS/400. Then either write a RPG/400 program to parse and extract or else use the CPYFRMIMPF command. Option 4- Write a VisualAge RPG program that can read directly from the PC and then parse it in VARPG and load it on the host database. Note that the CPYFRMIMPF is very scalable(in terms of number of fields), efficient and quick, however should you want more control then write programs on RPG/400.
    0 pointsBadges:
    report
  • MichelleDavidson
    We asked Search400.com subscribers if they had any advice. Here is what one person said: "Why not just use ISeries Client Access, go to Tools, select create an Physical file, use the scan function to create a physical file on the 400 and a FDF on the PC and transfer the file. It will even convert date formats, decimals, and punctuation." -- Michelle Davidson, editor, Search400.com
    435 pointsBadges:
    report
  • TomLiotta
    Copy the .CSV files to the QDLS... Do not get involved in trying to copy to the /QDLS file system. It should have dropped out of use by the time V5R1 came out a number of years ago. It's possible that you won't even be able to do it from your Win2K system even if you do work your way past all of the possible restrictions. And if you do get it to work, it will provide the worst performance out of the alternatives. It is obsolete. Use a different file system. Tom
    125,585 pointsBadges:
    report
  • Teandy
    You could always use FTP or map a drive to the IFS and then use CPYFRMIMPF to pull the data to a file on the i5.
    5,860 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following