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.

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