RE: How to transfer database files from PC to AS/400

Client Access (or CA Express) supplies the client-side ODBC drivers.  Host
Servers contains the AS/400-side ODBC servers.

Richard Jackson
mailto:richardjackson@richardjackson.net
http://www.richardjacksonltd.com
Voice: 1 (303) 808-8058
Fax:   1 (303) 663-4325

-|-----Original Message-----
-|From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
-|Behalf Of Peter Dow
-|Sent: Monday, October 16, 2000 12:13 AM
-|To: RPG400-L@midrange.com
-|Subject: Re: How to transfer database files from PC to AS/400
-|
-|
-|Hi Srinivas,
-|
-|A better place would be the Midrange-L list, since this is not actually an
-|RPG question. But as long as you're here, the answer is there are
-|many ways:
-|
-|1) Use ODBC from the PC to the AS400.
-|
-|2) Export the data as a comma-separated values (.csv) file, copy it to the
-|IFS (either with FTP or directly if you have Netserver running on the
-|AS400), then use CPYFRMIMPF on the AS400 to put it into a physical file.
-|
-|3) Export the data as .csv and use Client Access's data transfer utility.
-|
-|4) I think I heard someone mention that there's an ODBC driver for the
-|AS400. Presumably you could install that and have an AS400 program access
-|the PC database directly.
-|
-|And there are probably other methods I haven't thought of.
-|
-|HTH
-|Peter Dow
-|Dow Software Services, Inc.
-|909 425-0194 voice
-|909 425-0196 fax
-|
-|
-|----- Original Message -----
-|From: "G.R.Srinivas" <srinivasgr@yahoo.com>
-|To: <RPG400-L@midrange.com>
-|Sent: Saturday, October 14, 2000 6:30 AM
-|Subject: How to transfer database files from PC to AS/400
-|
-|
-|> Hello all,
-|> This may be a bit out of topic to some of you but this is related to
-|> AS/400.
-|> I would like to know how to transfer database files of other software
-|> like dBase III, dBase IV, Oracle.. etc from PC to AS/400?
-|> Thanx in advance.
-|> Srinivas.
-|>
-|>
-|> --- Ian Bunn <ian.bunn@progeny400.com> wrote:
-|> > Parvez,
-|> >
-|> > You first have to do a DSPMSGD of all of the messages that you want
-|> > to see
-|> > with OUPUT(*PRINT) specified.  You then need to copy the spool file
-|> > to a
-|> > database file using CPYSPLF remembering to use *FCFC for the control
-|> > character.  Then simply download the database to your Excel
-|> > spreadsheet.
-|> >
-|> > This is very tiresome, especially in a high impact development
-|> > environment.
-|> > To get around this, we developed a program that worked better than
-|> > the IBM
-|> > WRKMSGF command - it allows you copy, etc.  The MRGMSGF command comes
-|> > someway near to this but it doesn't allow you rename message Ids when
-|> > running the command.
-|> >
-|> > Regards
-|> >
-|> > Ian
-|> >
-|> >
-|> > ----- Original Message -----
-|> > From: Parvez Mirza <meinhindustani@hotmail.com>
-|> > To: <RPG400-L@midrange.com>
-|> > Sent: 18 September 2000 06:40
-|> > Subject: How tranfer *MSGF to Excel Spread Sheet/PC?
-|> >
-|> >
-|> > >
-|> > > Hi,
-|> > >
-|> > > How can I transfer the Message file from AS/400 to PC on a Excel
-|> > spread
-|> > > sheet?
-|> > >
-|> > > Thanx,
-|> > >
-|> > > Parvez.
-|> > >
-|> >
-|>
-|_________________________________________________________________________
-|> > > Get Your Private, Free E-mail from MSN Hotmail at
-|> > http://www.hotmail.com.
-|> > >
-|> > > Share information about yourself, create your own public profile at
-|> > > http://profiles.msn.com.
-|> > >
-|> > > +---
-|> > > | 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
-|> > > +---
-|> > >
-|> >
-|> > +---
-|> > | 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
-|> > +---
-|>
-|>
-|> __________________________________________________
-|> Do You Yahoo!?
-|> Yahoo! Messenger - Talk while you surf!  It's FREE.
-|> http://im.yahoo.com/
-|> +---
-|> | 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
-|> +---
-|
-|+---
-|| 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
-|+---

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