Ask the Expert

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 first published in June 2001

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

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
Sort by: OldestNewest

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: