(no subject)

[Guy Werry]

Ok, I'm coming from a different background and haven't done this exact
thing, so bear with me.

What I have done, quite successfully, is to use Oracle's Sql*Loader tool to
load data from flat files in a variety of formats (i.e., many different
styles of field terminators).  As I was typing this, Bob Edis' message
showed up saying essentially the same thing.  I agree with Bob that this is
the way to go.

		Roll out the wayback machine, and dust it off this is a
puzzler.... 
		The customer is on version (gulp) 6.10E on a microvax. No
chance of upgrading. No TCPIP available either, so I can't even think about
using an ODBC driver to read the RMS files. The only way I can connect to
the 
		machine is through RLAT. (Reflections LAT) I can transfer
the files off at high speed like FTP. 
		I need to transfer the data into Oracle.... I can't use QTP
to go directly to Oracle because the version of PH doesn't support Oracle. I
think my only alternative is to get the data to portable subfiles. 
		I have the schema already built in Oracle, though. 
		The customer was running a legacy ERP system called
Visibility. They want to get their history data into Oracle so that it can
live on forever and ever! From what I understand, Visibility used portable
subfiles and their own scripts to pump the data into Oracle. Any takers? 
		Thanks, 
		Sal Emma

G.L. (Guy) Werry 
Senior Systems Analyst
Hudson Bay Mining & Smelting
Ph:  204-687-2374
Fax: 204-687-2771
guy.werry@hbms.ca