Link to home
Start Free TrialLog in
Avatar of Blackie
Blackie

asked on

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.

Avatar of caraf_g
caraf_g

Hm... I've always used FTP successfully. Can you tell me what FTP commands you're using in what order?
Avatar of Blackie

ASKER

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.
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!
ASKER CERTIFIED SOLUTION
Avatar of Peter Price
Peter Price

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
caraf_g indeed missed some important points about FTP using a DOS client. <g>
Avatar of Blackie

ASKER

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.
Avatar of Blackie

ASKER

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.