sqlldr - sequence nextval

From: Ken Chesak <datavector_at_hotmail.com>
Date: 15 Apr 2003 09:20:30 -0700
Message-ID: <3f2f39c4.0304150820.2ba4efc2@posting.google.com>

I would like to use sequence.nextval to update column value in sqlldr. The column does not exist in the input file.

LOAD DATA
INFILE 'gws_case.dat'
APPEND
INTO TABLE benefit_case
FIELDS TERMINATED BY X'09' (

        id_benefit_case SEQUENCE(MAX,1),    <<< this works
        case_no ,
        id_seq

)

But I would like to use something like this, but I cant figure out the right syntax:

id_benefit_case SEQUENCE(sq_benefit_case.nextval)

I can use the SEQUENCE(MAX,1) but then I would need to update the sequence sq_benefit_case to the correct value after running sqlldr.

Thanks Received on Tue Apr 15 2003 - 11:20:30 CDT