| loading data that needs or condition [message #179779] |
Wed, 28 June 2006 13:02  |
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
|
Member |
|
|
hi all
right now i am working on sql loader and my base table have 4 columns(let say a,b,c,d) . now the requirement is that the data is loaded only if a,b is not null and abt c and d if either of that is not null . so "a" and b is compulsory along with either of c or d is present, then data is valid. (and iff both c and d are null then invalid data)
can u guide me the condition
becoz
when a!=BLANKS AND b!=blanks is fine but how to go for "c" and "d".
and we don't have "OR" in sqlloader
|
|
|
|
| Re: loading data that needs or condition [message #179823 is a reply to message #179779] |
Wed, 28 June 2006 22:44  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
You can kind of simulate an OR by including multiple load spec INTO the same table with different WHEN clauses. If that fails, try using an Externally Organized Table instead.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
