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