More info about portable subfile conversion.... the customer is on a REALLY old version of PH.
Sal Emma
semma@sysinc.com
Thu, 30 May 2002 15:28:31 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01C207EE.ABA2CFA0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
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
------=_NextPart_000_0001_01C207EE.ABA2CFA0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2713.1100" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial size=3D2>Roll =
out the wayback=20
machine, and dust it off this is a puzzler....</FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial size=3D2>The =
customer is on=20
version (gulp) 6.10E on a microvax. No chance of =
upgrading. =20
No TCPIP available either, so I can't even think about using an =
ODBC=20
driver to read the RMS files. </FONT></SPAN><SPAN=20
class=3D306191319-30052002><FONT face=3DArial size=3D2>The only way I =
can connect to=20
the </FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial =
size=3D2>machine is through=20
RLAT. (Reflections LAT) I can transfer the files off at high =
speed=20
like FTP. </FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial=20
size=3D2> </FONT></SPAN><SPAN class=3D306191319-30052002><FONT =
face=3DArial=20
size=3D2></FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial size=3D2>I need =
to transfer=20
the data into Oracle.... I can't use QTP to go directly to Oracle =
because=20
the version of PH doesn't support Oracle. I think my only=20
alternative is to get the data to</FONT></SPAN><SPAN=20
class=3D306191319-30052002><FONT face=3DArial size=3D2> portable =
subfiles. =20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial size=3D2>I have =
the schema=20
already </FONT></SPAN><SPAN class=3D306191319-30052002><FONT =
face=3DArial=20
size=3D2>built in Oracle, though. </FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial size=3D2>The =
customer was=20
running a legacy ERP system called Visibility. They want to get =
their=20
history data into Oracle so that it can live on forever and =
ever! =20
>From what I understand, Visibility used portable subfiles and their own =
scripts=20
to pump the data into Oracle. Any =
takers?</FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial=20
size=3D2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial size=3D2>Sal=20
Emma</FONT></SPAN></DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D306191319-30052002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV></BODY></HTML>
------=_NextPart_000_0001_01C207EE.ABA2CFA0--