Re: Getting an AS/400 Printout into Excel...

Thanks Pete,

I should have provided a little more info - we are on V3R6 and we execute 
STRHOSTSVR *ALL.
I'm using PC5250 but have played around with Telnet (the eval that was noted on 
this list  a while back - neat little program !
Yep, all the new stuff is "never a dull moment". Just wish I had the TIME to 
devote to it :-(
Once I got it rolling it WAS way cool ! GET lib/file file.txt and BOOM the 
AS.400 file is there.. Pretty slick (and a little scary...) <G>

Thanks !

Chuck

Pete Hall wrote:

> At 10:47 AM 6/30/98 -0400, Chuck Lewis wrote:
> >I tried starting FTP (and I am a real NOVICE when it comes to stuff like 
>this on
> >the AS/400) and I get "cannot connect to host xxxxxx.xxx.xxx.COM (where all 
>the
> >x's are valid names) at address xxx.xx.xx.x. (where all the x's are valid
> >numbers) try again.
> >
> >I can ping the AS/400 and I am connecting to the AS/400 via TCP/IP at my NT
> >Workstation. Host Servers is started (has to be started for me to connect 
>via CA
> >or I get an error), etc.
>
> Chuck,
>
> This is not necessarily true. It depends on how the host servers are started. 
>If they are started with the STRTCP command (V4R2), only the servers that are 
>configured to start automatically will be active. Try starting the FTP server 
>explicitly with STRHOSTSVR. After it runs, check your joblog. It will contain 
>a message about duplicate prestart job entries if the FTP server is already 
>running. Either way, it will not do any harm and FTP will be started when it 
>completes. Don't forget that the public authority for STRHOSTSVR as shipped 
>from Rochester is *EXCLUDE. Also, just in case, make sure you have the AS/400 
>defined in the HOSTS. table on your PC, although from your description, it 
>seems that you already do. When you connect via C/A, are you using TN5250? If 
>so, the connection is (except for the port) the same as FTP. I would suspect 
>either an authority problem (check QSYSMSG message queue for authority 
>exceptions) or an exit program, or maybe a nonstandard port.
>
> When I start command line FTP, it usually goes (approximately) something like 
>this:
>
> Me: FTP myhostname.com
> FTP: Enter user ID
> Me: MyUserId
> FTP: Enter Password
> Me: MyPassword
> FTP: Login Successful.
>
> Don't you just love having all this new stuff to figure out? The really cool 
>part is that when you finally get it working, it works great!!!
>
> hth
> Pete
>
> Pete Hall
> peteh@inwave.com
> http://www.inwave.com/~peteh/
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---