SQL Loader with more than 1 WHEN clause

 Hi, i want to load data with sql loader and have more than 1 WHEN clause.

e.g. ctl – file:

LOAD DATA

APPEND

INTO TABLE TABLE_SLOG

WHEN (ID = ' 0x11')

TRAILING NULLCOLS

   (

  STOP_TIME_CHAR  CHAR TERMINATED BY ";",

  INTERFACE       CHAR TERMINATED BY ";",

  ID                       CHAR TERMINATED BY ";",

  CREATION_DATE             "SYSDATE"

   )

 

 

I want also to load data if the ID = ' 0x11' OR ID = ' 0x12' OR  ID = ' 0x11'.

So I try to update the ctl-file:

 

LOAD DATA

APPEND

INTO TABLE TABLE_SLOG

WHEN (ID = ' 0x11' OR ID = ' 0x12' OR ID = ' 0x11')