SQl Loader - load I delimited file with different data types
I am trying to load a "I" delimited data file with different data records into the same table using WHEN clause and it is in version 8.0 (it does not know filler keyword yet). I use as follows:
APPEND
into table same_table_name
when (1)='XXX'
fields terminated by '|'
(...)
into table same_table_name
when (1)='YYY'
' fields terminated by '|'
(...)
It loads all records of type 'XXX' just fine and does not see actual data rows for the rest of the records - what's the problem, I thought WHEN clause should work , I used for the fixed length files before... Help is appreciated. Thanks.