Re: Can I use my own sequence with SQLLDR?

This works in 8.1.5, NT 4.0:

1. in sqlplus:

create table test (a number, c varchar2 (100)); create sequence s_test;

b) Create a controlfile test.ctl:

load data
append into table test
(

        c position (1)
        , a "s_test.nextval"

c) Test data in test.dat:

abc
def
ghijkl

d) Run the loader several times:

sqlldr control=test.ctl data=test.dat userid=whateveryourconnectstring
sqlldr control=test.ctl data=test.dat userid=whateveryourconnectstring
sqlldr control=test.ctl data=test.dat userid=whateveryourconnectstring

e) Do a select * from test;

Martin

jkc_at_consultant.com wrote:
>
> Does anyone know if I could use my own sequence when
> loading via sqlldr?
>
> something like:
>
> LOAD DATA
> INFILE 'load_test.dat'
> INTO TABLE test1
> fields terminated by ","
> (candidate_id MYSEQ.NEXTVAL,
> name )
>
> -John
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Feb 13 2000 - 07:55:40 CST