re: FTP from CL to a PC

>Is anyone successfully sending an AS/400 file to a PC within a CL program?
>
>Is there a write-up somewhere on how to do it?
>(I want to FTP the only member in file   QTEMP/ABC   to  123.45.67.1
>c:\home\abc.txt  as a comma-delimited file.
>
>tia.
>
>----------------------------------------------------
>Booth Martin


I wrote a program to do this a while back... The file is created as output
from an RPG program.  You're actually creating a 'CSV' file by hand:  you
need commas between the fields, you have to use Signed, not Packed, numeric
fields.  And any alpha field with embedded blanks has to have "double
quotes" around it.

I found it simpler to assume -all- alpha fields are fixed length.  I built
data structures &c to insert commas and quotes by brute force.

Once the file has been created, a CL program (or a command executed from
within the RPG program) will CPYTOPCD, which copies a data base file to a
Folder.  Once in the folder, you can access the file from any PC with
client access / Rumba as an "I:" or other mapped drive, or with Arpeggio or
other access program.

This doesn't actually 'send' the file to a PC, but makes the file available
to the PC, and doesn't require any intervention from the PC side to make it
so.

--Paul E Musselman
PaulMmn@ix.netcom.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@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
+---