Nice thought, but I think that Louis requires a fast mechanism from getting
data from a another source into an IB database. You can do this simply by
using normal inserts, but I think that having a component that exports from
a source into an external file format, then creating the "external table" in
the IB database and running the reverse of your syntax is what he wants to
do.

Just my take on his proposal. Personally i prefer to bridge the gap with an
import program e.g. MSSQL -> dataset -> FIBPlus SQL -> IB/FB. This way I
can morph and error correct data on route.

JAC
""Alan McDonald"" <alan@...> wrote in message
news:NBBBJKLIEJPCMJJOFDNPOECGFEAA.alan@......

> not sure what you are getting at here..
> if you create your external table ...
> then do
> insert into externaltable (field1, field2, etc) select (field1, field2 etc
> from internaltable
>
> wouldn't that do it for you?
> Alan
>
> -----Original Message-----
> From: Louis Kleiman [mailto:lkleiman@...]
> Sent: Saturday, 29 March 2003 3:22 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Writing to external files
>
>
> Well, I answered my own question and reverse engineered it. Man does FB

1.5

> load data fast. I loaded 1,000,000 records (8 integer fields and 1 double
> precision) in 26 seconds. I can write that same file in about 19 seconds.
> Yes, total data transfer of 1,000,000 records in 45 seconds.
>
>
>
> I think I will work on a Delphi component that can natively write a

dataset

> to a native FB external file format. Anyone interested?
>
>
>
> Louis Kleiman
>
> SSTMS, Inc.
>
>
>
>
>
> -----Original Message-----
> From: Louis Kleiman [mailto:lkleiman@...]
> Sent: Friday, March 28, 2003 4:30 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Writing to external files
>
>
>
> Hi All -
>
>
>
> I have a challenge for you:
>
>
>
> I want to write a file from a Delphi program that is compatible with a
> Firebird external file. "Easy", you say, "just make it ASCII and convert
> from ASCII to your numeric types with a CAST() when you load from the
> external file to your real table." Well, that would work, but I am really
> trying to save every possible millisecond here because I have some
> 10,000,000 line files to load. Can anyone tell me how to write files that
> are binary compatible with Firebird? I'll even restrict the data types:
> all I really need are INTEGER and DOUBLE PRECISION.
>
>
>
> I might be able to reverse engineer this, but I thought I would put it to
> the group to see if someone already knows.
>
>
>
> Thanks.
>
>
>
> Louis Kleiman
>
> SSTMS, Inc.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> Yahoo! Groups Sponsor
>
>
>
> ADVERTISEMENT
>
>

<http://rd.yahoo.com/M=245454.2994396.4323964.2848452/D=egroupweb/S=17051153

> 86:HM/A=1457554/R=0/*http:/ipunda.com/clk/beibunmaisuiyuiwabei>
>
>
>
>

<http://us.adserver.yahoo.com/l?M=245454.2994396.4323964.2848452/D=egroupmai

> l/S=:HM/A=1457554/rand=999838311>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo!
> <http://docs.yahoo.com/info/terms/> Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>