NULL and SQLLDR

From: <ibm_97_at_yahoo.com>
Date: Tue, 14 Dec 1999 21:01:45 GMT
Message-ID: <836b7k$m38$1@nnrp1.deja.com>

Table A has a NOT NULL column, and its value is white space.

I used the the following statement to create a flat file:

set.....
spool flatfile
select col_1||'ctrl-f'||ctrl_2||'ctrl-f'||col_3 from tableA;
spool off

When I use SQLLDR to load data, it complains that violate the NOT NULL constraint. What's wrong?

Thanks a lot!!!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 15:01:45 CST