SQL Loader Question

Hi ,

I am trying to use two sequences in my imports, One is meant to increment once per import and the other is meant to increment once per record imported. Any idea how I can do that?

i.e

LOAD DATA
INFILE 'something.csv'
REPLACE INTO TABLE the_table
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(

    IMPORT_NUMBER "???",

• How can I get this key to increment once per import
• instead of for each record imported? RECORD_KEY "record_seq.nextval" )

--
Gordy
ICQ 3290116
http://www.geocities.com/Area51/Cavern/4253


Sent via Deja.com http://www.deja.com/
Before you buy.