SQL*Loader question

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 6 Dec 2000 17:02:32 -0500
Message-Id: <10702.123857@fatcity.com>

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_01C05FD0.3BB418CE
Content-Type: text/plain;

charset="iso-8859-1"

Hi everyone,

I know this has been discussed before. Below the controlfile is inserting a sequence number into a table along with the data. I'm very rusty with SQL*Loader. Does anyone see anything wrong with this control file? There is indeed a column for a sequence number primary key in this table.

Any suggestions are appreciated.
Thanks

>  -----Original Message-----
> From: 	Metzler, Larry  
> Sent:	Wednesday, December 06, 2000 4:58 PM
> To:	Koivu, Lisa
> Subject:	on my way over
> 
> 
> LOAD DATA 
> APPEND
> INTO TABLE load_rebate
> FIELDS TERMINATED BY ","
> (
> rec_no SEQUENCE(1,1),
> url_variable, 
> manu_part_number nullif manu_part_number = blanks,
> ingrammicro_sku nullif ingrammicro_sku=blanks,
> upc nullif upc=blanks,
> manufacturer nullif manufacturer = blanks,
> title nullif title = blanks,
> rebate filler,
> blargy filler,
> end_date,
> flargy filler)
> 
>  -----Original Message-----
> From: 	Koivu, Lisa  
> Sent:	Wednesday, December 06, 2000 4:28 PM
> To:	Naginsky, Irina; Metzler, Larry
> Subject:	
> 
> I should make you both buy me booze for making such a fool of me...  then
> again I guess I'm pretty gullible. 
> 
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL  33319
> 
> V: 954.484.3191, x174
> F: 954.484.2933 
> C: 954.658.5849
> http://www.qode.com
> 
> "The information contained herein does not express the opinion or position
> of Qode.com and cannot be attributed to or made binding upon Qode.com."
>

------_=_NextPart_001_01C05FD0.3BB418CE
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>SQL*Loader question</TITLE>
</HEAD>
<BODY>

Hi everyone, 


I know this has been =
discussed before.  Below the controlfile is inserting a sequence = number into a table along with the data.  I'm very rusty with = SQL*Loader. Does anyone see anything wrong with this control = file?  There is indeed a column for a sequence number primary key = in this table.

Any suggestions are =
appreciated. 
 Thanks


 -----Original Message-----
 From:   Metzler, Larry  
 Sent:   =
Wednesday, December 06, 2000 4:58 =
PM
 To:     Koivu, Lisa
 Subject:       </FONT= > on my way over

 

LOAD DATA 
 APPEND
 INTO TABLE load_rebate
 FIELDS TERMINATED BY =
","
 (
 rec_no SEQUENCE(1,1),
 url_variable, 
 manu_part_number nullif =
manu_part_number =3D blanks,
 ingrammicro_sku nullif =
ingrammicro_sku=3Dblanks,
 upc nullif upc=3Dblanks,
 manufacturer nullif manufacturer =3D =
blanks,
 title nullif title =3D =
blanks,
 rebate filler,
 blargy filler,
 end_date,
 flargy filler)

<UL>
 -----Original Message-----
 From:   Koivu, Lisa  
 Sent:   =
Wednesday, December 06, 2000 4:28 =
PM
 To:     Naginsky, Irina; Metzler, Larry
 Subject:        =



I should make you both buy me booze =
for making such a fool of me...  then again I guess I'm pretty = gullible. 


Lisa Rutland Koivu
 Oracle Database Administrator
 Qode.com
 4850 North State Road 7
 Suite G104
 Fort Lauderdale, FL  =
33319


V: 954.484.3191, x174
 F: 954.484.2933 
 C: 954.658.5849
 <A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A>


"The =
information contained herein does not express the opinion or position = Received on Wed Dec 06 2000 - 16:02:32 CST