Re: Transfer of AS/400 File to PC (Excel)

[rob@xxxxxxxxx]

There is a FAQ section set up at www.midrange.com

Try this:
http://faq.midrange.com/index.pl?_highlightWords=ftp&file=67

And yes, this should have been on midrange-l, not rpg400-l.

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.


                                                                                
                                       
                    bschmuhl@att.net                                            
                                       
                    Sent by:                 To:     RPG400-L@midrange.com      
                                       
                    owner-rpg400-l@mi        cc:                                
                                       
                    drange.com               Subject:     Re: Transfer of 
AS/400 File to PC (Excel)                    
                                                                                
                                       
                                                                                
                                       
                    05/29/01 09:10 AM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       




use the STRTCPFTP command and put your commands in a
text file. Use the OVRDBF command to override file INPUT
to the file where your commands are and override file
OUTPUT to another test file where you will get the
status information of what happened to the commands.
> Hi Murtuza,
>
> Your given example (script) is fine if you transfer a file from one
AS/400
> to other AS/400 and this fine with me also. But I want to transfer a
> physical file from AS/400 to my PC. Following is my simple script for the
> same but giving error messages while being called from a CL program:
>
>
****************************************************************************

> **********
> username password
> PUT BPCDUSRF/SALEF.JANMBR  E:/ANALYSIS/
> CLOSE
> QUIT
>
****************************************************************************

> **********
> Can you advice how to accomplish it.
>
> Thanks for all support.
>
>
> Amir
> System Analyst, SCC,
> K.S.A.
> (00-966-03-8344500 X267)
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




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