Hi guys,

I've been following the discussion about data pumping but do not
understand some of the suggestions:

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

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

And last:

>- Also be very careful when assigning source fields to destination params.
>Avoid calls like FieldByName or ParamByName absolutely, or at least do your
>mapping before the loop and use exlusively field and param *objects* in the
>loop.

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

--
Best regards,
Alexander mailto:saho@...