Re: uploading file through FTP to as/400

[Jim Langston <jimlangston@xxxxxxxxxxxxxxxx>]

It depends on how you save your data.  I did the same thing from Excel to 
the AS/400 using the printer format .PRN (Formatted Text).  This gave fixed
width columns, and worked the best for what I was doing.  Here is some sample
output:

Name         AgePhone NumberAddress
Joe Scmhoe    33(310) 555-121313 Mockingbird Lane
Nunya Busines 72(562) 555-121122 Boogie Boogie Avenue
John Doe      12(213) 555-12123 Anystreet

Excel determines each columns lenght dependant on the maximum length.  This file
is very easily brought into a OS400 file (CPYF FMTOPT(*NOCHK) works fine).

HTH

Regards,

Jim Langston

If you save your data

> Jayakrishnan_PV wrote:
> 
> Hi Guys,
>   I have a query regarding file upload from PC to AS/400 in the absence of 
>Client Access interface. Through FTP it can be done as the Excel data can be  
>copied in a flat file. The problem is that the character data in different 
>columns get merged into single field value.
> 
>   I need a suggestion with respect to how can I upload the data in various 
>columns into different fields of an AS/400 file.
> 
> Regds....
> Jaya
+---
| 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
+---