Help !!! File transfer from AS/400 to PC

Hello all,

I'm trying to transfer an AS/400 File up to my PC using Client Access V3R1M2.

I don't know why the file won't upload correctly. When I look at the file on
the AS/400 it consists of 3 character fields which contain text .i.e:-

"This system is designed to"

However NO matter what option I use to upload this data to my PC, I'm
getting HEX details of the file..see below

4040404040404040404040404040404040404040404040404040404040404040404040E38182
938540968640C39695A38595A3A2404040404040404040404040404040404040404040404040
40404040404040404040404040404040404040404040404040404040404040F04BF14040C4C9E2D7D3C1E87A40E2E3C1D5C4C1D9C440C6C5C1E3E4D9C5B404B404B404B404B404B404B404B404B404B
4040F1F040404040404040404040404040404040404040


I have tried to do an upload of printing the file etc, but I still get the same garbage.
Somebody said I could use FTP to bring the file from the AS/400 down to the PC but when I type in FTP and my as400server at a DOS prompt and use the GET command to try to retrieve the file onto my PC, it comes back and tells me it's not connected. (Prior to this I have started FTP on my AS/400).

What am I doing wrong ?

Note: Even when I use an ODBC Link to access the data it's still coming up
as the above junk.!!

Any  ideas ??

C.

BlackieAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
P_S_PriceConnect With a Mentor Commented:
caraf q has missed some important points about FTP using a DOS client.

If the session just comes back FTP> it probably has not connected you. Usually the DOS FTP client session when connected to an AS/400 FTP server session provides you with information about where you are connecting and requests that you input a user, followed by a password without the need to issue the USER subcommand.

Have you checked on your AS/400 to make sure that the necessary TCP/IP applications are active (GO TCPADM & then work with TCP applications) FTP may not work if the server application is not up. You may also need to use your system name rather than an explicit IP address with the FTP dos command. (you can establish a system name from your PC5250 emulation session).

Once you are correctly signed on (before you issue the get) you should make sure that you are in the correct library on the AS/400 (CD MYLIB) & Directory on the PC (LCD C:\MYDIR)

Another Point the GET may need the (replace option if the file already exists on the PC. Also note that PC Code Page & AS/400 File CCSID values may cause unexpected characters to appear in the data once downloaded.

Also note that the Naming format is important when establishing what member to download.

0
 
caraf_gCommented:
Hm... I've always used FTP successfully. Can you tell me what FTP commands you're using in what order?
0
 
BlackieAuthor Commented:
Hi Caraf q,

I'm new to experts-exchange so not quite sure if I'm answering you correctly.!!!

Basically we have TCP/IP running on our AS/400 @ V4R1M0, and from a DOS line on my PC I key in FTP (and address of our as/400, in the format ('1.1.1.2').

After a few minutes the PC prompt comes back with :

FTP>

When I key in the 'GET' command specifying the AS/400 file and the PC text file I want to transfer it into, it comes back with "Not connected".

....That's where I am at the moment.!!

P.S. Just had a rumage though your history and I would like to say a 'BIG THANK YOU', as it seems you have been pretty instrumental in activating an AS/400 topic area.

I have to admit I was excited to see this section, as I find this site really great.!!

Regards
C.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
caraf_gCommented:
Okeydokey..

You're standing in front of the entrance of your AS/400, but you haven't got in yet.

After you get the
FTP> prompt type in
user <followed by your user name>
then it will prompt you with
password <you enter your password>

now you're connected, and you can GET the file.

PS - if you get the file like this, you'll get it in PC format. If you execute the command
binary
before you do the GET, you'll get the original EBCDIC data.

Hope this helps!
0
 
caraf_gCommented:
caraf_g indeed missed some important points about FTP using a DOS client. <g>
0
 
BlackieAuthor Commented:
PS Price,

Thanks for your reply. I'm new to this group so haven't got the hang yet of what points to award to answers, also I'm low on points at the moment so I have to be frugile.!!

I think that Caraf g really deserve 20 of these points as he had pointed me on the right path.
However I don't know if I explained what I wanted to do correctly...but it was to download a file from the AS/400 to the PC, so therefore I was FTP'ing at my PC and NOT the AS/400 screen. !!

Once again thank you both for your replies. I am truly very excited about finding this site.

Don't know if I'm allowed do this..but sure what the heck!!
On an AS400 Newsgroup some people had recommended that I change the forcetranslation line in the CWBTFR.INI File, but I couldn't locate this anywhere. I'm running ordinary CA.

Any ideas??

C.
0
 
BlackieAuthor Commented:
PS Price,

Thanks for your reply. I'm new to this group so haven't got the hang yet of what points to award to answers, also I'm low on points at the moment so I have to be frugile.!!

I think that Caraf g really deserve 20 of these points as he had pointed me on the right path.
However I don't know if I explained what I wanted to do correctly...but it was to download a file from the AS/400 to the PC, so therefore I was FTP'ing at my PC and NOT the AS/400 screen. !!

Once again thank you both for your replies. I am truly very excited about finding this site.

Don't know if I'm allowed do this..but sure what the heck!!
On an AS400 Newsgroup some people had recommended that I change the forcetranslation line in the CWBTFR.INI File, but I couldn't locate this anywhere. I'm running ordinary CA.

Any ideas??

C.
0
All Courses

From novice to tech pro — start learning today.