Subject Re: [firebird-support] RE: Bulk data loading
Author Helen Borrie
At 07:41 AM 4/06/2004 -0400, you wrote:
>Helen,
>
>LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'

OK, forget all that syntax. The nearest equivalent is
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