--- David Brown <[EMAIL PROTECTED]> wrote:
> We
> end up with over 3,000,000 rows in one table, with
> every column null. This
> last time it inflated the size of the RB2 file from
> a normal 33MB up to
> 406MB,
> SET QUOTES = "
> LOAD cheques FRO .vfile AS ASCII
> SET QUOTES = '
First off, although I'm sure it's not the cause of
your problem, I think the correct syntax for the load
command should be:
LOAD cheques FROM &vFile AS ASCII
Is it possible that the file you were loading from
when the process failed was corrupted at the end -- in
particular, could it have been missing the CTRL-Z end
of file marker? That might lead R:Base to continue
past the end of the file and try to load whatever
garbage it found on the disk -- stuff that probably
couldn't be resolved into the correct data types and
would therefore appear as NULLs in the database.
--
Larry
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
