RE: Loading Table Informix 5
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_01BF9458.D0A05B8A
Content-Type: text/plain;
charset="iso-8859-1"
Check out the dbload utility.
HTH,
Paul Mosser
-----Original Message-----
From: Jon Borys [mailto:jborys@rms.moore.com]
Sent: Wednesday, March 22, 2000 3:46 PM
To: informix-list@iiug.org
Subject: Loading Table Informix 5
I want to load a table from a text file using the load command. The
table has unique key constraints on it and some of the records I'm
attempting to load cause it to fail. Is it possible to have the load
command keep loading after it has problem with a record and output to a
file all of the records that failed to load? Thanks in advance.
------_=_NextPart_001_01BF9458.D0A05B8A
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: Loading Table Informix 5</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Check out the dbload utility.</FONT>
</P>
<P><FONT SIZE=2>HTH,</FONT>
<BR><FONT SIZE=2>Paul Mosser</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Jon Borys [<A HREF="mailto:jborys@rms.moore.com">mailto:jborys@rms.moore.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, March 22, 2000 3:46 PM</FONT>
<BR><FONT SIZE=2>To: informix-list@iiug.org</FONT>
<BR><FONT SIZE=2>Subject: Loading Table Informix 5</FONT>
</P>
<BR>
<P><FONT SIZE=2>I want to load a table from a text file using the load command. The</FONT>
<BR><FONT SIZE=2>table has unique key constraints on it and some of the records I'm</FONT>
<BR><FONT SIZE=2>attempting to load cause it to fail. Is it possible to have the load</FONT>
<BR><FONT SIZE=2>command keep loading after it has problem with a record and output to a</FONT>
<BR><FONT SIZE=2>file all of the records that failed to load? Thanks in advance.</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01BF9458.D0A05B8A--