Helen

Thank you for forwarding the help file to me directly. Unfortunately
the explanation of BASE: didn't enlighten me much!

> >I have just been trying the datapump facility for the first time

and

> >have had mixed success.
> >With very simple src SQL like 'select * from table where

field=value'

> >and dst SQL 'select * from table' it seems to be missing out some
> >columns.
>
> src should be a SELECT, dst should be an INSERT.
>
> Also, use explicit column lists in both the src and dst statements.

This is disappointing and incovenient since 'select *' is alot less
effort then typing in a whole insert statement!

>
>
> >If I look at ItemActions and click prepare then all the included
> >columns have ColumnName=DIRECT and the excluded have

ColumnName=BASE:

>
> What makes you think they are excluded? The ones which IBO can't

convert

> are marked =UNASSIGNED or =SKIPPED
>

The destination columns are null :-)

Regards
Paul