Subject RE: [firebird-support] Import data from flat files
Author Oleg Lebedev
Actually, when I said that only 90% or rows were imported, I was basing
this on the count(*) query run against the external table.
I created the external table as follows:

EXTERNAL 'orders.tbl'
o_orderkey int NOT NULL ,
o_custkey int NOT NULL ,
o_orderstatus char (1) NOT NULL ,
o_totalprice decimal(18, 0) NOT NULL ,
o_orderdate timestamp NOT NULL ,
o_orderpriority char (15) NOT NULL ,
o_clerk char (15) NOT NULL ,
o_shippriority int NOT NULL ,
o_comment varchar (79) NOT NULL

Here are a couple of lines from my orders.tbl file:

1|36901|O|173665.47|1996-01-02|5-LOW|Clerk#000000951|0|blithely final
dolphins solve-- blithely blithe packages nag blith
2|78002|O|46929.18|1996-12-01|1-URGENT|Clerk#000000880|0|quickly regular
alongside of the dependencies are slowly about
4|136777|O|32151.78|1995-10-11|5-LOW|Clerk#000000124|0|final requests
detect slyly across the blithely bold pinto beans. eve
5|44485|F|144659.20|1994-07-30|5-LOW|Clerk#000000925|0|even deposits
cajole furiously. quickly spe
SPECIFIED|Clerk#000000058|0|ironically bold asymptotes sleep blithely
beyond the regular, clos
7|39136|O|252004.18|1996-01-10|2-HIGH|Clerk#000000470|0|ironic, regular
deposits are. ironic foxes sl
32|130057|O|208660.75|1995-07-16|2-HIGH|Clerk#000000616|0|slyly final
foxes are slyly. packag

I wonder if the problem could be with using bars to separate field
So, in any case, the orders.tbl file contains 1,500,000 lines, but only
90% of them get imported.
Do you see anything wrong with what I am doing here?


-----Original Message-----
From: Milan Babuskov [mailto:albis@...]
Sent: Tuesday, September 30, 2003 9:44 AM
Subject: Re: [firebird-support] Import data from flat files
Importance: Low

Oleg Lebedev wrote:
> It worked, thanks.
> I guess it's a new feature, because I wasn't able to find it in the
> Language Reference guide.

Yes, it is.

> Still, I was able to import only about 90% of rows.

Probably some rows couldn't be converted becuse of bad formatting? Have
you tried doing select count(*) from external_table ?

How did you declare your external table? Can you post the DDL here,
please. I suggest that you use only char fields so that you can catch
conversion errors when doing INSERT INTO...

> I tried to enable the write-through cache, but now I can't drop my
> existing table, because it says that object ORDERS is in use. Does it
> always happen when write-through is enabled?

Not really. It sounds more like problem with uncommited transaction.
Before dropping the table always make sure you are the only user
connected, and that you have commited all transactions.

> After I restarted the FB server, ran
>>gfix -write sync
> and re-imported the data, I was still missing 10% of the rows. Maybe
> my file is messed up, but it worked for other databases.

Please post few lines from your file, and your external table DDL so we
have more detail to help you.

Milan Babuskov

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to


This e-mail may contain privileged or confidential material intended for the named recipient only.
If you are not the named recipient, delete this message and all attachments.
Unauthorized reviewing, copying, printing, disclosing, or otherwise using information in this e-mail is prohibited.
We reserve the right to monitor e-mail sent through our network.