Subject | Re: [ib-support] importing lots of rows |
---|---|
Author | Claudio Valderrama C. |
Post date | 2002-04-10T23:42:13Z |
"Raphael Bauduin" <raphael.bauduin@...> wrote in message
news:20020409134038.GD4974@raphael...
the external table to skip them. And you have to define a final dummy field
for the record of one or two CHAR's, depending on whether your file is LF or
CRLF terminated.
There's a program that supposedly dumps records in the examples directory,
but it's totally outdated and has not been touched for years. You better
look at other utilities if you don't want to define external tables.
C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing
news:20020409134038.GD4974@raphael...
> Hi,external
>
> > Similar...but not identical - but if you can export your data in fixed
> > format, you can define the output file inside the database as an
> > table.If you can't change the format, you can define dummy fields of one CHAR in
>
> I export the data in this format:
>
> field1|field2|field3|field4|field5|
the external table to skip them. And you have to define a final dummy field
for the record of one or two CHAR's, depending on whether your file is LF or
CRLF terminated.
There's a program that supposedly dumps records in the examples directory,
but it's totally outdated and has not been touched for years. You better
look at other utilities if you don't want to define external tables.
C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing