SQL Loader NULLIF clause

[drkestrel]

I have problem in using the NULLIF clause to set a Numeric field to null If either-
a) it contains blanks or
b) it contains -1

the or is what I couldn't get SQLLoader to work!

Load Data

infile 'test.dat'

REPLACE
INTO TABLE userData

(

VALUE	POSITION(185:187)	INTEGER EXTERNAL NULLIF (VALUE=BLANKS)
)

I tried or , but no luck!!

 

[karluk]

This is just a guess, but I would try

NULLIF (VALUE in (BLANKS, -1))

If that doesn't work, and you don't want to spend time figuring out the exact syntax, just load the table including the -1 values and execute an update statement later to change -1 to null.