Migrating AIX C-ISAM data to AIX Oracle DB

Fri, 18 Feb 2005 06:07:58 +0200

This is a multi-part message in MIME format.

------_=_NextPart_001_01C5156F.6E0DE302
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Why not use PowerHouse QTP? Subfile out, subfile in.
Neil
=20

________________________________

From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Brett Greiner
(Kinetix)
Sent: 18 February 2005 03:31 AM
To: powerh-l@lists.sowder.com
Subject: Migrating AIX C-ISAM data to AIX Oracle DB

=09
Hi All,

We are investigating on how much effort is required to migrate AIX
C-ISAM data files to anAIX Oracle Database.

We did export 1000 records to a portable subfile, but it required adding
a Carrigae-Return character at the end of the record and it also places
a + sign in front of numerics?

Are there tools that are available for use?
Has anyone done this before, if so how have they done this?

Thanks,
Brett.

=20

=20

------_=_NextPart_001_01C5156F.6E0DE302
Content-Type: text/html;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Kinetix</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2604" name=3DGENERATOR>
<SCRIPT language=3DJavaScript type=3Dtext/JavaScript>
<!--

function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init=3D=3Dtrue) with (navigator) {if =
((appName=3D=3D"Netscape")&&(parseInt(appVersion)=3D=3D4)) {
    document.MM_pgW=3DinnerWidth; document.MM_pgH=3DinnerHeight; =
onresize=3DMM_reloadPage; }}
  else if (innerWidth!=3Ddocument.MM_pgW || =
innerHeight!=3Ddocument.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</SCRIPT>

<STYLE type=3Dtext/css>
<!--
style1 {color: #002558}
body {
	background-image: url(kinetix.gif);
}
-->
</STYLE>
</HEAD>
<BODY=20
style=3D"FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: Arial; =
BACKGROUND-COLOR: #ffffff"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D406030704-18022005>Why not use =
PowerHouse=20
QTP? Subfile out, subfile in.</SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN =
class=3D406030704-18022005>Neil</SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN =
class=3D406030704-18022005></SPAN>&nbsp;</DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma><B>From:</B> powerh-l-admin@lists.sowder.com=20
[mailto:powerh-l-admin@lists.sowder.com] <B>On Behalf Of </B>Brett =
Greiner=20
(Kinetix)<BR><B>Sent:</B> 18 February 2005 03:31 AM<BR><B>To:</B>=20
powerh-l@lists.sowder.com<BR><B>Subject:</B> Migrating AIX C-ISAM data =
to AIX=20
Oracle DB<BR></FONT><BR></DIV>
<DIV></DIV>
<TABLE style=3D"WIDTH: 897px; HEIGHT: 438px" cellPadding=3D5 width=3D897 =
border=3D0>
  <TBODY>
  <TR>
    <TD><FONT size=3D2></FONT></TD></TR>
  <TR>
    <TD vAlign=3Dtop>
      <P><SPAN class=3D875472601-18022005><FONT size=3D2>Hi =
All,</FONT></SPAN></P>
      <P><SPAN class=3D875472601-18022005><FONT size=3D2>We are=20
      investigating&nbsp;on how much effort is required to migrate AIX =
C-ISAM=20
      data files to anAIX Oracle Database.</FONT></SPAN></P>
      <P><SPAN class=3D875472601-18022005><FONT size=3D2>We did export =
1000 records=20
      to a portable subfile, but it required adding a Carrigae-Return =
character=20
      at the end of the record and it also places a + sign in front of=20
      numerics?</FONT></SPAN></P>
      <P><SPAN class=3D875472601-18022005><FONT size=3D2>Are there tools =
that are=20
      available for use?<BR>Has anyone done this before, if so how have =
they=20
      done this?<BR></FONT></SPAN></P>
      <P><SPAN class=3D875472601-18022005><FONT=20
      size=3D2>Thanks,<BR>Brett.</P></FONT></SPAN></TD></TR>
  <TR>
    <TD>
      <DIV align=3Dleft>&nbsp;<MAP name=3DMap><AREA shape=3DRECT=20
        coords=3D60,130,157,142 href=3D"http://www.kinetix.co.nz"><AREA =
shape=3DRECT=20
        coords=3D41,118,158,130=20
  =
href=3D"mailto:brett@kinetix.co.nz"></MAP></DIV></TD></TR></TBODY></TABLE=
>
<P>&nbsp;</P></BODY></HTML>

------_=_NextPart_001_01C5156F.6E0DE302--