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

Still, I was able to import only about 90% of rows.
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?

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.
Thanks.



-----Original Message-----
From: Hans Hoogstraat [mailto:hans@...]
Sent: Monday, September 29, 2003 2:52 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Import data from flat files
Importance: Low


More info in

Firebird_v15_ReleaseNotes.draft1.pdf

in your Firebird install folder

---------------------------------------

----- Original Message -----
From: "Oleg Lebedev" <oleg.lebedev@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, September 29, 2003 2:32 PM
Subject: RE: [firebird-support] Import data from flat files


| Great, thanks.
| Setting ExternalFileAccess = full solved the problem with external
| files' permissions.
|
| I was finally able to import the Orders table in my external tables,
| but instead of returning the count of 1,500,000 rows it returns
| 1,175,279. So, I guess it missed a whole bunch of rows during the
| import.
|
| Now, I am trying to figure out what went wrong during the import. So,
| I want to view the first couple of rows in the table. But, it seems
| like there is no way to limit the number of rows returned by the query

| and it tries to dump all the rows at once. This is sad. Ideas? Thanks.
|
| -----Original Message-----
| From: Hans Hoogstraat [mailto:hans@...]
| Sent: Monday, September 29, 2003 1:59 PM
| To: firebird-support@yahoogroups.com
| Subject: Re: [firebird-support] Import data from flat files
| Importance: Low
|
|
| Turn the option on in FireBird.Conf
|
| ----------------------------------------
| ----- Original Message -----
| From: "Oleg Lebedev" <oleg.lebedev@...>
| To: <firebird-support@yahoogroups.com>
| Sent: Monday, September 29, 2003 1:41 PM
| Subject: RE: [firebird-support] Import data from flat files
|
|
| |
| | Hmm, I have access to a Win machine, but I need to figure out how to

| | this on Linux.
| |
| | External tables solution sounded like a good idea. But every time I
| | try to create my table using the:
| |
| | Create Table Orders External '/tmp/orders.tbl' (.....);
| |
| | It throws an error saying that "Access to external file
| | /tmp/orders.tbl is denied by server administrator". I checked the
| | read/write permissions on this file to allow reads, but still have
| | the
|
| | same problem. Ideas?
| |
| | Thanks.
| |
| |
| | -----Original Message-----
| | From: Rafael Szuminski [mailto:raf@...]
| | Sent: Monday, September 29, 2003 1:14 PM
| | To: firebird-support@yahoogroups.com
| | Subject: Re: [firebird-support] Import data from flat files
| | Importance: Low
| |
| |
| | uh, yeah... that would be a problem ;-)
| |
| | Do you have any Windows machines on the network that you could
| | transfer the data from? I always do all my 'data' work on the
| | Windows and then copy the ready file to the Linux server.
| |
| | Raf
| |
| |
| | Oleg Lebedev wrote:
| |
| | > It doesn't seem to work on Linux.
| | >
| | > -----Original Message-----
| | > From: Rafael Szuminski [mailto:raf@...]
| | > Sent: Monday, September 29, 2003 12:53 PM
| | > To: firebird-support@yahoogroups.com
| | > Subject: Re: [firebird-support] Import data from flat files
| | > Importance: Low
| | >
| | >
| | > How about IBPump?
| | > (http://www.clevercomponents.com/products/datapump/ibdatapump.asp)
| | >
| | > Just copy the data out of MSSQL or any other ADO data source.
| | >
| | > Raf
| | >
| | >
| | > Oleg Lebedev wrote:
| | >
| | >
| | >>Sory, I fogot to mention that I need to be able to import files
| | >>into
|
| | >>the FireBird database running on Linux RedHat 8.0. I have 1 GB of
| | >>data
| | >
| | >
| | >>to import, so I need a pretty fast utility for that. The best
| | >>would be
| | >
| | >
| | >>a similar to GBAK utility that can import data from flat files
| | >>into DB
| | >
| | >
| | >>tables. Any ideas?
| | >>Thanks.
| | >>
| | >>Oleg
| | >>
| | >>
| | >>-----Original Message-----
| | >>From: M Tuttle [mailto:miket@...]
| | >>Sent: Monday, September 29, 2003 11:15 AM
| | >>To: firebird-support@yahoogroups.com
| | >>Subject: Re: [firebird-support] Import data from flat files
| | >>Importance: Low
| | >>
| | >>
| | >>SMImport at http://www.scalabium.com/
| | >>
| | >>----- Original Message -----
| | >>From: "alecswan2001" <oleg.lebedev@...>
| | >>To: <firebird-support@yahoogroups.com>
| | >>Sent: Monday, September 29, 2003 11:03 AM
| | >>Subject: [firebird-support] Import data from flat files
| | >>
| | >>
| | >>
| | >>
| | >>>I am trying to run some TPC benchmarks on the FireBird database.
| | >>>I have just performed these tests on PostgreSQL by importing data

| | >>>from the flat files and running TPC-R queries. Is there a
| | >>>FireBird utility
| |
| | >>>that would read data from comma- separated flat files and insert
| | >>>data
| |
| | >>>into the tables? Something similar to the COPY command in
| | >>>PostgreSQL that copies data from a file to a table.
| | >>>
| | >>>Thanks.
| | >>>
| | >>>Oleg
| | >>>
| | >>>
| | >>>
| | >>>To unsubscribe from this group, send an email to:
| | >>>firebird-support-unsubscribe@yahoogroups.com
| | >>>
| | >>>
| | >>>
| | >>>Your use of Yahoo! Groups is subject to
| | >>>http://docs.yahoo.com/info/terms/
| | >>>
| | >>>
| | >>>
| | >>
| | >>
| | >>
| | >>
| | >>
| | >>To unsubscribe from this group, send an email to:
| | >>firebird-support-unsubscribe@yahoogroups.com
| | >>
| | >>
| | >>
| | >>Your use of Yahoo! Groups is subject to
| | >>http://docs.yahoo.com/info/terms/
| | >>
| | >>*************************************
| | >>
| | >>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.
| | >>
| | >>*************************************
| | >>
| | >>
| | >>To unsubscribe from this group, send an email to:
| | >>firebird-support-unsubscribe@yahoogroups.com
| | >>
| | >>
| | >>
| | >>Your use of Yahoo! Groups is subject to
| | >>http://docs.yahoo.com/info/terms/
| | >>
| | >>
| | >>
| | >
| | >
| |
| | --
| | Rafael Szuminski
| | Email:raf@...
| | Phone:(949)939 - 2458
| | www.BDCSoftware.com
| |
| |
| |
| | To unsubscribe from this group, send an email to:
| | firebird-support-unsubscribe@yahoogroups.com
| |
| |
| |
| | Your use of Yahoo! Groups is subject to
| | http://docs.yahoo.com/info/terms/
| |
| | *************************************
| |
| | 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.
| |
| | *************************************
| |
| |
| | To unsubscribe from this group, send an email to:
| | firebird-support-unsubscribe@yahoogroups.com
| |
| |
| |
| | Your use of Yahoo! Groups is subject to
| | http://docs.yahoo.com/info/terms/
| |
| |
| |
|
|
|
| To unsubscribe from this group, send an email to:
| firebird-support-unsubscribe@yahoogroups.com
|
|
|
| Your use of Yahoo! Groups is subject to
| http://docs.yahoo.com/info/terms/
|
| *************************************
|
| 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.
|
| *************************************
|
|
| To unsubscribe from this group, send an email to:
| firebird-support-unsubscribe@yahoogroups.com
|
|
|
| Your use of Yahoo! Groups is subject to
| http://docs.yahoo.com/info/terms/
|
|
|



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

*************************************

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.

*************************************