Alexander,

> >- load all records from the as/400 und store them directly in the
> > ascii files (without using firebird !!)
>
> What do you mean by that? Using raw data access to the file. Where can
> I see the format of external files?

External tables are simple ascii files. For a description look in the data
definition guide for Interbase6 (located on www.ibphoenix.com)

> >- pump all records with an sql statement from the external table
> > in the final table
>
> Does it mean that I must have one external and one final table, so
> after populating the external I must select everything and insert it
> into the final table?

yes, but you can use one sql statement for this

select * from matchcode_external
insert into matchcode

> What is the main reason for this. I do not think that using
> ParamByName would be slow. Is there anything else?

Because a ParamByName must compare the given paramname with the internal
fieldnames an iterate through all fields.

--
marco krause