Subject | Re: [firebird-support] RE: Bulk data loading |
---|---|
Author | Helen Borrie |
Post date | 2004-06-04T12:39:47Z |
At 07:41 AM 4/06/2004 -0400, you wrote:
CREATE TABLE <table-name> EXTERNAL <filesystem-path-name> (see
LangRef.pdf). Your input file needs to be in fixed field format. This
allows you to query the external data file as though it were a table. You
can, for example, write a stored procedure to massage the data and store it
in any way you like.
/heLen
>Helen,OK, forget all that syntax. The nearest equivalent is
>
>LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
CREATE TABLE <table-name> EXTERNAL <filesystem-path-name> (see
LangRef.pdf). Your input file needs to be in fixed field format. This
allows you to query the external data file as though it were a table. You
can, for example, write a stored procedure to massage the data and store it
in any way you like.
/heLen