Migrating AIX C-ISAM data to AIX Oracle DB

Brett Greiner (Kinetix) Brett@Kinetix.co.nz
Fri, 18 Feb 2005 14:30:43 +1300


This is a multi-part message in MIME format.

------_=_NextPart_001_01C51559.765AFFB8
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

=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_01C51559.765AFFB8
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"><!-- Fireworks MX Dreamweaver MX target.  Created =
Thu Jun 12 13:20:07 GMT+1200 (New Zealand Standard Time) 2003-->
<META content=3D"MSHTML 6.00.2800.1491" 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>
<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_01C51559.765AFFB8--