Subject RE: [firebird-support] Re: Problem in Bulk Insertion in Firebird
Author Alan McDonald
> I'm stuck in another problem now..
> I did it like this:
> 1. Create EXTERNAL TABLE (TEMP1) with the file (dump.txt) i have dumped.
> 2. Then i inserted values in my original table (tb1) like
> INSERT INTO tb1 SELECT TRIM(TRAILING '\0' FROM col1),col2 .. from TEMP1;
> But while executing this query i got following problem after few
> minutes....
> I/O error for file fseek "D:\TEMP\dump.txt" Error while trying to open
> file.
> Info: My dump.txt file is almost 3 GB.
> Is it memory issue i mean.. due to low memory.
> Or is it something else..
> Please help me

I suppose you realise that external files need to be fixed field length char
files only?
You are talking about \0 (nulls) - I don't suppose you are imagining that
any old file format is suitable to use as an external file?