Re: Generating PC file formats from AS/400 data

[Jerome Draper <jdraper@xxxxxxx>]

Synapse NetWolf will download data from the AS/400 to a PC over TCP/IP with
it's SQL based file transfer.  Multiple output file types are supported.
The dBase (.dbf) is directly readable by Excel and includes column
headings, sizes, and types pulled from the DDS specs on the AS400 so you
don't have to do any manipulation in Excel to format and/or label the data.  

The key is that the user can click to do the download and then open the
result file in Excel (.dbf) and get work done without any further data
modification and definitions.  .CSV files fail in this regard and put the
process back into the domain of the (heaven forbid) programmer.

The file transfer will operate in a batch mode so you could automate the
downloading and distribution of 1000 files.  

It is also callable from C++ or VB where it uses a messaging system to
monitor the success or failure of a file transfer and subsequent processing.

SNA is supported in their WinAPPC version.

Ordinary folk can use this software.

A free full running demo is at http://www.synapse.com.  

(Claimer:  I sell, support, use, and recommend Synapse products).

Regards,



Jerry


At 01:55 PM 8/9/2000 EDT, you wrote:
>There are an infinity of standard packages that copy almost any AS/400 file 
>or spool file to almost any PC format.  Their interfaces are often designed 
>for the non-technical ORDINARY PERSON who should be able to do their job 
>without having to become an expert on what is going on under the covers.  Do 
>we have to understand the workings of an automobile or TV set to turn it
on & 
>use it?
>
>Now if the employer wants to hire ordinary people but not pay the money to 
>provide them ordinary tools to get their job done, then that is an ordinary 
>scenario.
>
>> My users are also challenged by the download/import process
>


Jerry Draper, Trilobyte Software Systems, since 1976
Specializing in connecting PC's, Windows, MAC's, and LAN's to the AS/400
Representing Synapse, Apple, UDS, Nlynx, Perle, Lucent, etc.
(415) 457-3431; (415) 258-1658fax; jdraper@wco.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---