RE: ##EMailNumber 01-WNY-3319101 RTOPCB Question -- MIDRANGE-L

Eric,

FTP is not always a good replacement for file transfer. FTP takes the
entire file, period. If you want to perform any kind of record or field
selection you are stuck with file transfer or other SQL based transfer. 

-Walden

PS. Yes, I know that you could build a SQL view on the AS/400 and then
FTP that to perform record and field selection, but that's too much of a
pain for one-off tranfers.

-----Original Message-----
From: Eric [mailto:Eric@norcov.com]
Sent: Wednesday, June 17, 1998 12:40 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: ##EMailNumber 01-WNY-3319101 RTOPCB Question


Jorge,

Has your developer considered using FTP instead.  He could easily do an
FTP 
GET command from the PC.  I am sure that it would be a faster and easier

implementation and transfer.

Eric Kempter
Director of MIS
Commair Mechanical Services

-----Original Message-----
From:   jmoreno@militarycars.com [SMTP:jmoreno@militarycars.com]
Sent:   Wednesday, June 17, 1998 6:24 AM
To:     midrange-L@midrange.com
Subject:        ##EMailNumber 01-WNY-3319101 RTOPCB Question


One of  our Programming Developers Is trying to Work with RTOPCB and
has encountered some problems. I am forwarding his question to the
mailing
list.
Thanks for your answers in advance

Jorge
This Is The Question :
---------------------- Forwarded by Jorge A Moreno/Military Car Sales on

06/17/98 10:19 AM ---------------------------

Ryan A. Martin
06/17/98 10:07 AM

To:     Jorge A Moreno/Military Car Sales@Military Car Sales
cc:
Subject:        RTOPCB problem
E-Mail Ref #:   01-WNY-2658917

I am trying to create a batch transfer from AS/400 to PC using Client 
Access 3.1.2. As far as I can tell, the tool provided for such tasks is
a 
32-bit version of RTOPCB. I've created a set of .TTO files using the
CWBTF 
program for Windows 95, but this program runs interactively and I need
to 
move a group of more than 50 files. It's quite tedious to transfer them
all 
interactively.  The only problem is that the RTOPCB program fails with
an 
error message "Unable to connect to <system>." My connection to the
AS/400 
is a native Winsock 1.1 connection. I've verified that all the host
servers 
are running on the AS/400, both the QSERVER and QSYSWRK subsystems are 
started, and the TCP/IP interface is up. I've got the sinking feeling
that 
I need to use APPC over IP to get this to work. However, since I can do 
file transfers with CWBTF under my current configuration, I would be 
somewhat surprised to find that RTOPCB was limited to AnyNet - it
wouldn't 
really make sense.  Is there any way to use RTOPCB with a Winsock 1.1 
connection? Any ideas what might be going wrong?


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

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