Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Discarding records with SQLLDR
Hi,
I'm importing data with sqlldr (v8.1.6). I don't want to load a record if a specific field is negative. Is there some way to do this?
I tried:
load data
append
into table mytable
when my_column <= 0
(Col1 char terminated by '|',
my_column decimal external terminated '|')
but that didn't work. It seems that the operator in the when clause can only be a "=" or "<>".
I've been looking through the doc (and the web) and I can't find a similar example.
Any help would be appreciated
Thanks
Jay
-- Jay jjstrauss_at_yahoo.comReceived on Tue Apr 03 2001 - 15:24:09 CDT
![]() |
![]() |