Alexander Tabakov wrote:

>>- 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?

See in the docs. These are simple ascii files with fixed-length-rows.

>>- 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 and no. You don't have to populate external table, you just "attach"
it (i.e. the ascii file). You do have to select and insert everything
from it.


--
Milan Babuskov
http://fbexport.sourceforge.net