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

Dig Deeper on FTP

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.