How to load a CONSTANT NULL
509207Apr 6 2010 — edited Apr 7 2010I"m getting the error message:
SQL*Loader: Release 11.1.0.6.0 - Production on Tue Apr 6 15:28:37 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL*Loader-350: Syntax error at line 71.
Expecting valid column specification, "," or ")", found "NULL".
SERVER NULL,
^
I want to fill a field with the constant value of NULL. How can I do that? I have a control file that looks similiar to this:
-- Load Records for 2009 January (31 Days)
OPTIONS (DIRECT=TRUE, READSIZE=10000000)
LOAD DATA
INFILE 'access_log-boola-01.' BADFILE 'access_log-boola-01.bad' DISCARDFILE 'access_log-boola-01.discard'
APPEND
INTO TABLE WEBLOGS.WLOGIMP
(
WLOGIMPID SEQUENCE(MAX,1),
SERVER CONSTANT NULL,
USERAGENT CHAR(1000) TERMINATED BY WHITESPACE ENCLOSED BY '"'
)
Thanks,