RE: How to transfer AS/400 data file through FTP

If the PC data base has a import utility, like SQLLDR in Oracle, the easiest
thing is to create a text file in the 400 IFS (CPYTOIMPF) in a format the
data import utility can handle, FTP the text file, and run the import
utility on the PC.  If you can't use ODBC or some other direct access
method, you're limited to exporting and importing a text file. 

> -----Original Message-----
> From: Jim Langston [mailto:jimlangston@conexfreight.com]
> Sent: Wednesday, April 18, 2001 10:21 AM
> To: RPG400-L@midrange.com
> Subject: Re: How to transfer AS/400 data file through FTP
> 
> 
> FTP is a File Transfer Protocol.  Unfortunately, it doesn't 
> work on the
> record level (Hmm... is there an RTP?).
> 
> So.. you are going to have to come up with some scheme to get 
> the records,
> once transferred, from the file into your database.  On the 
> AS/400 it's 
> relatively easy, run remote command to copy the file adding 
> the records is
> probably the easiest way.
> 
> But, on the PC, your options are limited.  Can you think of a 
> way, any way,
> to take this file on the PC into your database file?  
> 
> Regards,
> 
> Jim Langston
> 
> Ahmed Hussain wrote:
> > 
> > Hi all,
> > 
> > We are on v4R2.
> > 
> > I am looking for a FTP procedure through which I can 
> transfer AS/400 data file to PC data
> > base file, I know how to do this through Client Access, but 
> I need to do this with FTP.
> > 
> > Any help would highly be appreciated.
> > 
> > Thanx
> > 
> > Ahmed Hussain
> > 
+---
| 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
+---