Re: PC Data files and the AS/400

[Jerome Draper <jdraper@xxxxxxx>]

At 08:38 PM 5/6/98 -0400, you wrote:
>Does any know if their is a way to to take data from the AS/400 and put it
>directly into a pcdata file like Betreive.  Can you tell the AS/400 that the
>data file is a remote file and sql into it?  Or can you use ILE RPG to do
>this.  I would also be interested if you could do this with access also.

I used to program extensively in Btrieve (originally Softcraft? then
Novell, and now back to another company name when Novell spun it off).
Btree is simply an efficient  file indexing system available from many
companies typically in programmer toolkit forms.

It would be relatively straightforward to write a pgm in C or VB that
would, using ODBC, read a record from an AS400 database and write it to
your Btrieve database.  Most ODBC software (like HiT ODBC) use DRDA to
improve speed.

I like the Btrieve brand because it pre-images all file changes so that you
never have to worry about losing data when (not if) the system crashed (you
know, when users press the ole CTL-ALT-DLT during file updates or power
outages).  Of course, ya can't CTL-ALT-DEL an AS/400 thank goodness (but
why isn't CA/400 as durable as and AS/400?).

Jerry



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, IBM, UDS, Nlynx, MI, DCI, Netsoft, 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 unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---