More info about portable subfile conversion.... the customer
is on a REALLY old version of PH.
Edis, Bob
BEdis@usbnc.org
Thu, 30 May 2002 14:32:41 -0500
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C20810.C37C7E10
Content-Type: text/plain;
charset="iso-8859-1"
G'day Sal
6.10E, ahh, a good vintage. A Viz to Oracle conversion? A lot of that
going on but a bad investment.
Write the data to CSV ASCII files and use the Oracle DataLoader to put the
data in the tables. This would work with the portable subfiles too if you
know the record layouts. This requires a bit of upfront work in defining
the record layouts to DataLoader but once ready it is really fast.
Blue
-----Original Message-----
From: Sal Emma [mailto:semma@sysinc.com]
Sent: Thursday, May 30, 2002 2:29 PM
To: powerh-l@lists.swau.edu
Subject: More info about portable subfile conversion.... the customer is on
a REALLY old version of PH.
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_001_01C20810.C37C7E10
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 5.50.4916.2300" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=375512819-30052002>G'day
Sal</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=375512819-30052002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=375512819-30052002>6.10E,
ahh, a good vintage. A Viz to Oracle conversion? A lot of that going
on but a bad investment.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=375512819-30052002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=375512819-30052002>Write
the data to CSV ASCII files and use the Oracle DataLoader to put the data in the
tables. This would work with the portable subfiles too if you know the
record layouts. This requires a bit of upfront work in defining the record
layouts to DataLoader but once ready it is really fast.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=375512819-30052002></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=375512819-30052002>Blue</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Sal Emma
[mailto:semma@sysinc.com]<BR><B>Sent:</B> Thursday, May 30, 2002 2:29
PM<BR><B>To:</B> powerh-l@lists.swau.edu<BR><B>Subject:</B> More info about
portable subfile conversion.... the customer is on a REALLY old version of
PH.<BR><BR></FONT></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>Roll out the
wayback machine, and dust it off this is a puzzler....</FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>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. </FONT></SPAN><SPAN
class=306191319-30052002><FONT face=Arial size=2>The only way I can connect to
the </FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>machine is through
RLAT. (Reflections LAT) I can transfer the files off at high speed
like FTP. </FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>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</FONT></SPAN><SPAN
class=306191319-30052002><FONT face=Arial size=2> portable
subfiles. </FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>I have the schema
already </FONT></SPAN><SPAN class=306191319-30052002><FONT face=Arial
size=2>built in Oracle, though. </FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>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?</FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial size=2>Sal
Emma</FONT></SPAN></DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=306191319-30052002><FONT face=Arial
size=2></FONT></SPAN> </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C20810.C37C7E10--