SEQUENCE QUESTION FOR SQLLOADER

[FRANK]

I am loading a table using sqlloader and the the primary key of the table that is being loaded is a sequence. If I don't specify that column in my control file when I do a fixed format field load, will the column generate it's sequence number or do I have to specify something in my control file?

[marist89]

Yes, you must specify the SEQUENCE keyword in the control file. (See [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76955/ch04.htm#3100[/url] )

[FRANK]

I've been looking through some case studies about sequences
Even if I'm am appending rows to the table and the sequence parameters are alredy set in the table? Could you show me an example? I don't seem to have access to that site that you gave me?

[marist89]

LOAD DATA
INFILE *
APPEND
INTO TABLE emp
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(empno, ename, job, mgr,
hiredate DATE(20) "DD-Month-YYYY",
sal, comm, deptno CHAR TERMINATED BY ':',
projno,
loadseq SEQUENCE(MAX,1))