Re: How to load a complete empty record using sqlldr?

From: <michael_bialik_at_my-deja.com>
Date: Sat, 12 Jun 1999 19:48:31 GMT
Message-ID: <7judid$g54$1_at_nnrp1.deja.com>


Hi.
 Try using "PRESERVE BLANKS" clause in your LOAD command.  You can find a complete description of that clause in  "Server Utility User's Guide"

  Good luck. Michael.

In article <7jmq9a$126$1_at_nnrp1.deja.com>,   ewong74_at_netscape.net wrote:
> Hi there,
>
> I have a ascii data file(separated by |) with 2 fields and thousands
of
> rows. One of the rows(the first row) is completely empty. The data
> file looks like:
>
> |
> aaa|bbb
> ccc|ddd
> eee|fff
>
> If I do a load using sqlldr, the first record(the one completely
empty)
> are always discarded. Is there a way to load a completely empty row
> using sqlldr? You may ask why I need to load a empty record into the
> db. This is for some data relationship purpose that I must do. And
I
> don't want to do a insert ... values ('','') every time after the db
is
> refreshed.
>
> Thanks!
>
> Ed
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 12 1999 - 21:48:31 CEST

Original text of this message