Try select 'first n skip m field1,field2,.. from table', to get back any
desired no of records from any starting point

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

----- 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/
|
|
|