Unanswered: SQL*Loader - Selective data load based on SYSDATE
I'm a sqlldr newbie and am trying to update some automated loading code. I have a text file which is uploaded to a table in the database using sqlldr. positions (1:6) in the file are a date field in "YYMMDD" format. I don't want to load any lines where the date field is equal to today.
It would seem to me that the following should work (but it doesn't). What am I missing?
into table my_data
WHEN (1:6) != TO_CHAR(TRUNC(SYSDATE), 'YYMMDD')
GREETING CONSTANT 'HI_MOM',
IMPL_DATE POSITION(1:6) DATE "YYMMDD"
This isn't a life and death. We are dumping to a temporary table, so I can filter at that point, where I am more comfortable with the code. However, I would like to know if this filtering possible with sqlldr?