| sqlldr when [message #266806] |
Tue, 11 September 2007 12:33  |
mjgerry3006
Messages: 4
Registered: September 2007
Location: albany,ny
|
Junior Member |
|
|
shoudl be simple enough, but can not find
I only wish to load to a table if a specific column is NOT NULL
into table ....
when column is not null (no good)
not null (no good)
<> null (no good)
ideas please ?
|
|
|
|
|
|
| Re: sqlldr when [message #266816 is a reply to message #266814] |
Tue, 11 September 2007 12:59  |
mjgerry3006
Messages: 4
Registered: September 2007
Location: albany,ny
|
Junior Member |
|
|
Im missing something - its flat file now.
I want to integeragte one column, and if NOT Null, load a table(internal)
I error out with
"Expecting quoted string or hex identifier, found "NULL".
WHEN(NATIONAL_DRUG_CODE_E1856 = NULL)"
Seems to not recogize "NULL"
|
|
|
|
| Re: sqlldr when [message #266818 is a reply to message #266806] |
Tue, 11 September 2007 13:05 |
mjgerry3006
Messages: 4
Registered: September 2007
Location: albany,ny
|
Junior Member |
|
|
|
I mean I could load to a staging table, then use sql to only load the rows that the column is populated in.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
