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

Transfer a text file to the database on the AS/400

I want to transfer a text file to a database on my AS/400 without the inclusion of the srcseq and srcdat fields....

I only want the srcdta field to be transferred.

The best way to send a text file to an AS/400 file is by using FTP.

1. From the windows issue the command ftp xx.xx.xx.xx where xx.xx.xx.xx is your AS/400 IP address.

2. Enter your user name and password.

3. You will receive ftp session prompt type the following:

 ftp > ascii
ftp > put pcfile as400file

(pcfile = name of the text file on the pc
as400file - as400 file name. file will be created if
not exist)

ftp > quit

You are done. The resulting file on the as400 has the
text only (no srcseq etc). 

This was last published in June 2001

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.

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

Please create a username to comment.