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

["Mike Silvers" <msilvers@xxxxxxxxxxx>]

Amir,

I would copy the database file to a stream file, then FTP the stream file to
the PC.  Use the command CPYTOSTMF to copy the database file to a stream
file, then use the same FTP script, but replace the qualified file name with
a qualified IFS file name.

Mike

----- Original Message -----
From: "Amir Khan" <akhan@saudicement.com.sa>
To: "Midrange RPG (E-mail)" <RPG400-L@midrange.com>
Sent: Tuesday, May 29, 2001 6:29 AM
Subject: Transfer of AS/400 File to PC (Excel)


> 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
+---