RE: SQL*Loader question

From: Bala, Prakash <Prakash_Bala_at_bscc.bls.com>
Date: Wed, 6 Dec 2000 17:48:25 -0500
Message-Id: <10702.123867@fatcity.com>

Lisa, this should work.  

Prakash

-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Wednesday, December 06, 2000 5:06 PM To: Multiple recipients of list ORACLE-L Subject: SQL*Loader question

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 <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 Received on Wed Dec 06 2000 - 16:48:25 CST