Ftp Files from PC Server to AS400

50 pts.
Tags:
AS/400
Hardware
This is a new project and I am totally lost and am hoping someone can guide me in the right direction. The project entails writing a CL to bring over flat files from a PC Server and the files will be stored in a partition on the AS400. It's not much to go on but that is all I know at the moment. Would anyone be able to share any ideas and/or thoughts. Please ask me questions and I will ask my management hopefully for some answers. Sincerely, Marci

Answer Wiki

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

Here is one example that might help you…goode luck!!
On the AS/400 create a flat physical file. This file will contain the User ID and Password to sign for the system, the FTP command will be executed. This file will also contain the FTP commands (PUT, GET..).

Example Flat File Containing the FTP Commands

USERID PASSWORD
binary
put Library/File Library/File
quit
Replace the USERID and PASSWORD in the example file with a valid User ID and Password for the system the FTP will be executing to.

Now to execute the FTP file defined above in a batch job, you need to override the file created above to a file name of INPUT. Then all you need to do is execute FTP with the System Name or IP Address.

Example CL Commands to Execute the FTP

OVRDBF FILE(INPUT) TOFILE(FILECREATEDABOVE)
FTP RMTSYS(’100.100.1.1′)
DLTOVR FILE(*ALL)

Discuss This Question: 2  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
  • LDLDLD69
    You could use FTP, Client Access to transfer the files from the PC to the AS/400. You could also map a network drive on the PC and send it over to the As/400, and there is also that there are vendors out there that you could buy software as well. These Flat Files are they from an EDI Software package????
    35 pointsBadges:
    report
  • Howard2nd
    A - Are you using the AS/400 as a 'file server'? So other PC's can access this 'flatfile'? B - Are you using the AS/400 as an 'applications server'? Is a program on the 400 going to manipulate the 'flatfile'? C - Any chance that it is DB2? Is this a setup for importing data, and is it one time or regular updates? D - Are you just running OS/400, or multiple virtual machines? If Linux or Windows Server, what versions? That should get you started.
    30 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