I have to import a csv dataset and some fields that are indexed in the table are not in the csv data.
Loader gives an error stating that those fields are required. is there a way to import the data and set for the index fields that are not available a default value? DATALOAD TABLE DBA.cars_used record_id 1 DEFAULT NULL dealer_name 2 DEFAULT NULL ..... (cut) car_make_display 10 DEFAULT NULL car_model_display 11 DEFAULT NULL INFILE 'cars_used.txt' COMPRESSED ASCII SEPARATOR '|' DELIMITER '' I would like to add a few lines like car_make_code DEFAULT '99' car_model_code DEFAULT '99' to set a value of 99 to columns that are not represented in the csv data What is the correct syntax, if this functionality is available at all? I could not find anything in the docs... I would create the real values for car_make_code and car_model_code with a query after the import. Thanks -Zavier
