Migrating AIX C-ISAM data to AIX Oracle DB

Fri, 18 Feb 2005 08:33:46 -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_01C515BE.78C98750
Content-Type: text/plain;
	charset="iso-8859-1"

Brett,

Your best bet is to define a SQLLDR .ctl file for the C-ISAM file in it's
native form.  I have moved allot of data to Oracle and it is by far the
fastest way.

Tim Cummings
Cincinnati, OH

-----Original Message-----
From: Brett Greiner (Kinetix) [mailto:Brett@Kinetix.co.nz]
Sent: Thursday, February 17, 2005 8:31 PM
To: powerh-l@lists.sowder.com
Subject: Migrating AIX C-ISAM data to AIX Oracle DB

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.

------_=_NextPart_001_01C515BE.78C98750
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>Kinetix</TITLE>

<META content="MSHTML 6.00.2800.1491" name=GENERATOR>
<SCRIPT language=JavaScript type=text/JavaScript>
<!--

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

<STYLE type=text/css>
<!--
.style1 {color: #002558}
body {
	background-image: url(kinetix.gif);
}
-->
</STYLE>
</HEAD>
<BODY 
style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff" 
bgColor=#ffffff leftMargin=0 topMargin=0>
<DIV><SPAN class=906582713-18022005>Brett,</SPAN></DIV>
<DIV><SPAN class=906582713-18022005></SPAN>&nbsp;</DIV>
<DIV><SPAN class=906582713-18022005>Your best bet is to define a SQLLDR .ctl 
file for the C-ISAM file in it's native form.&nbsp; I have moved allot of data 
to Oracle and it is by far the fastest way.</SPAN></DIV>
<DIV><SPAN class=906582713-18022005></SPAN>&nbsp;</DIV>
<DIV><SPAN class=906582713-18022005>Tim Cummings</SPAN></DIV>
<DIV><SPAN class=906582713-18022005>Cincinnati, OH</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT 
  face=Tahoma>-----Original Message-----<BR><B>From:</B> Brett Greiner (Kinetix) 
  [mailto:Brett@Kinetix.co.nz]<BR><B>Sent:</B> Thursday, February 17, 2005 8:31 
  PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Migrating AIX 
  C-ISAM data to AIX Oracle DB<BR><BR></FONT></DIV>
  <TABLE style="WIDTH: 897px; HEIGHT: 438px" cellPadding=5 width=897 border=0>
    <TBODY>
    <TR>
      <TD><FONT size=2></FONT></TD></TR>
    <TR>
      <TD vAlign=top>
        <P><SPAN class=875472601-18022005><FONT size=2>Hi All,</FONT></SPAN></P>
        <P><SPAN class=875472601-18022005><FONT size=2>We are 
        investigating&nbsp;on how much effort is required to migrate AIX C-ISAM 
        data files to anAIX Oracle Database.</FONT></SPAN></P>
        <P><SPAN class=875472601-18022005><FONT size=2>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?</FONT></SPAN></P>
        <P><SPAN class=875472601-18022005><FONT size=2>Are there tools that are 
        available for use?<BR>Has anyone done this before, if so how have they 
        done this?<BR></FONT></SPAN></P>
        <P><SPAN class=875472601-18022005><FONT 
        size=2>Thanks,<BR>Brett.</P></FONT></SPAN></TD></TR>
    <TR>
      <TD>
        <DIV align=left>&nbsp;<MAP name=Map><AREA shape=RECT 
          coords=60,130,157,142 href="http://www.kinetix.co.nz"><AREA shape=RECT 
          coords=41,118,158,130 
    href="mailto:brett@kinetix.co.nz"></MAP></DIV></TD></TR></TBODY></TABLE>
  <P>&nbsp;</P></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C515BE.78C98750--