SQL*Loader - Update Not Insert

[gsdcrazy]

Gurus,

This is probably a very elementary question, but I am frustrated. How to I set SQL*Loader to update existing rows, but not insert new rows when the record does not exist in the table? I have tried

LOAD DATA
REPLACE
INTO TABLE ag_ma_indicator_trans
(ENTITY_ID position(001:010) char,
MA_ALLOWED_IND position(011:011) char,
MA_ELECTION_CHG_DATE position(012:019) date 'MMDDYYYY',
AG_ALLOWED_IND position(020:020) char,
AG_ELECTION_CHG_DATE position(021:028) date 'MMDDYYYY',
CLERK_ID position(029:038) char
)

but the REPLACE seems to insert new rows when the key (ENITITY_ID) does not exist in the table. I would like the records to go to the BAD file or, at least, somewhere else.

Any help would be greatly appreciated.

Thanks,
gsdcrazy

 

[taupirho]

sqlload your data into a temporary table then use the SQL UPDATE command to update your main data based on the values in your temp table

 

[gsdcrazy]

taupirho,

Thanks. Guess I just wanted SQL*Loader to do something that it can not. I'll implement your solution.

Thanks again,
gsdcrazy