Re: Excel 97 & AS/400 Data conversion problems

[boothm@xxxxxxx]

I am moving data from the AS/400 directly to our web page.  I gotta tell
you, it blows my mind.  But I am using tcp/ip, not  Client Access or ODBC.  


I am using a couple of ways: one is to FTP the file directly to a server,
and using code page 437.  That works for pure text, but it does drop
trailing blanks.  To take care of numbers and so forth I am making an
output file on the AS/400 and am program-describing it.  That way, all the
numbers go as formatted text, with edit codes, so the numbers have
decimals, minus signs, etc.

The other way I've used is to do a CPY from the AS/400 to the AS/400's IFS
system.  CPY is not CPYF so far as I can see, and it has some advantages. 
It makes a Streamfile on the IFS, and it allows the records to travel as
full length records, keeping trailing blanks.  Then, FTPing from the IFS
is a piece of cake. -- 
-----------------------------------------------------------
boothm@ibm.net
-----------------------------------------------------------

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