Re: SQL Loader - Detecting blank fields using WHEN
Date: 9 Jun 2004 06:03:51 -0700
Message-ID: <4092f6be.0406090503.174dffa1_at_posting.google.com>
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1086757894.142997_at_yasure>...
> stevie wrote:
<snip>
> > BEGINDATA
> > 04A01,11
> > 76301,13
> > 76301,13,A
> > 76301,13
> > 79601,13
> > 79601,14,034
> > 79601,13,174
> > 79601,13,314
>
> What third column ... I only see a single comma
> Fields terminated by comma ... take a look at your data
The rows of data may have 2 or 3 columns as you can see. I need to
detect whether the row is a 2col or 3col row. That is why the control
file has a WHEN FIELD3=''. I tried WHEN FIELD3 IS NULL but SQLLDR
rejected this syntax.
Even if I imply that there is a 3rd col, by changing the first data
row to '04A01,11,' this has no impact and the row is still ignored.
Stevie
Received on Wed Jun 09 2004 - 15:03:51 CEST