I want to load a table with an opional lob-column. The control file looks something like that:
OPTIONS (ERRORS=50)
LOAD DATA
CHARACTERSET UTF8
INFILE 'HLFG_PI_TELEGRAMM_DATA_TABLE.ldr' "str '{EOL}'"
REPLACE
CONTINUEIF NEXT(1:1) = '#'
INTO TABLE "PI"."TELEGRAMM"
FIELDS TERMINATED BY'|'
OPTIONALLY ENCLOSED BY '"' AND '"'
TRAILING NULLCOLS (
"TGR_ID" ,
"NAME" CHAR (30),
"XSDPATH" CHAR (200),
ext_fname FILLER CHAR(255),
"XSD" LOBFILE(ext_fname) terminated by eof,
"XSDVALMODE" CHAR (5),
"IMPORT_PROCEDURE" CHAR (255),
"ACTIVATED" CHAR (1))
The Lobfile "XSD" may or may not be available. Unfortunately I get the error "SQL*Loader-646" for all records without the Lobfile - and these records are not imported. What I want is: load all records regardless of the Lobfile existing or not.
How can I modify the control file to make column XSD optional?
Thanks,
Stephan